DBA Data[Home] [Help]

APPS.HR_PROCESS_CONTACT_SS dependencies on HR_COMMENTS

Line 82: ,hr_comments hc

78: pcr.object_version_number
79: FROM
80: per_contact_relationships pcr
81: ,per_all_people_f pap
82: ,hr_comments hc
83: WHERE pcr.contact_relationship_id = p_contact_relationship_id
84: AND pcr.contact_person_id = pap.person_id
85: AND p_eff_date BETWEEN pap.effective_start_date and pap.effective_end_date
86: AND hc.comment_id (+) = pap.comment_id;

Line 17045: ,hr_comments hc

17041: pcr.object_version_number ovn
17042: FROM
17043: per_contact_relationships pcr
17044: ,per_all_people_f pap
17045: ,hr_comments hc
17046: WHERE pcr.contact_relationship_id = p_contact_relationship_id
17047: AND pcr.contact_person_id = pap.person_id
17048: AND p_eff_date BETWEEN pap.effective_start_date and pap.effective_end_date
17049: AND hc.comment_id (+) = pap.comment_id;