NEED TO JOIN TABLES HRMS

[sajid]

HI,
I need join between the following tables

per_appraisal_templates pat,
per_appraisals pa,
per_all_people_f papf,
hr_questionnaires hq,
hr_quest_answers hqa,
HR_QUEST_ANSWER_VALUES HQAV

is used the following joins but i didn't get the actual data which i need

papf.person_id = pa.appraisee_person_id and
pat.appraisal_template_id = pa.appraisal_template_id and
hq.questionnaire_template_id = pat.questionnaire_template_id and
hqa.questionnaire_template_id = hq.questionnaire_template_id AND
HQAV.QUESTIONNAIRE_ANSWER_ID = HQA.QUESTIONNAIRE_ANSWER_ID AND

[ahmadbilal]

why you dont go to etrm for Complete ERD?