eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 16851: ,hr_comments hc

16847: pcr.object_version_number ovn
16848: FROM
16849: per_contact_relationships pcr
16850: ,per_all_people_f pap
16851: ,hr_comments hc
16852: WHERE pcr.contact_relationship_id = p_contact_relationship_id
16853: AND pcr.contact_person_id = pap.person_id
16854: AND p_eff_date BETWEEN pap.effective_start_date and pap.effective_end_date
16855: AND hc.comment_id (+) = pap.comment_id;