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.

APPS.PER_PL_CON_INFO dependencies on PER_CONTACT_RELATIONSHIPS

Line 13: cursor cur_crl is select 1 from per_contact_relationships

9: P_CONTACT_PERSON_ID NUMBER,
10: P_PERSON_ID NUMBER,
11: P_CONTACT_TYPE VARCHAR2,
12: P_DATE_OF_BIRTH DATE) IS
13: cursor cur_crl is select 1 from per_contact_relationships
14: where contact_person_id = p_contact_person_id
15: and person_id = p_person_id
16: and contact_type in ('01','11','21','30','31','32','33','40','41','50','60')
17: and P_CONTACT_TYPE in ('01','11','21','30','31','32','33','40','41','50','60')

Line 87: cursor cur_crl is select 1 from per_contact_relationships

83: P_DATE_START DATE,
84: P_DATE_END DATE,
85: P_CONTACT_TYPE VARCHAR2) IS
86:
87: cursor cur_crl is select 1 from per_contact_relationships
88: where contact_person_id in
89: (select contact_person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
90: and person_id in (select person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
91: and contact_relationship_id <> p_contact_relationship_id

Line 89: (select contact_person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)

85: P_CONTACT_TYPE VARCHAR2) IS
86:
87: cursor cur_crl is select 1 from per_contact_relationships
88: where contact_person_id in
89: (select contact_person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
90: and person_id in (select person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
91: and contact_relationship_id <> p_contact_relationship_id
92: and contact_type in ('01','11','21','30','31','32','33','40','41','50','60')
93: and P_CONTACT_TYPE in ('01','11','21','30','31','32','33','40','41','50','60')

Line 90: and person_id in (select person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)

86:
87: cursor cur_crl is select 1 from per_contact_relationships
88: where contact_person_id in
89: (select contact_person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
90: and person_id in (select person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
91: and contact_relationship_id <> p_contact_relationship_id
92: and contact_type in ('01','11','21','30','31','32','33','40','41','50','60')
93: and P_CONTACT_TYPE in ('01','11','21','30','31','32','33','40','41','50','60')
94: and (date_start >= p_date_start

Line 99: per_contact_relationships where contact_relationship_id = P_CONTACT_RELATIONSHIP_ID);

95: OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));
96:
97: cursor csr_dob_contact is
98: select date_of_birth from per_all_people_f where person_id in (select contact_person_id from
99: per_contact_relationships where contact_relationship_id = P_CONTACT_RELATIONSHIP_ID);
100:
101: l_contact_dob per_all_people_f.date_of_birth%TYPE;
102: nDummy_val number;
103: l_proc varchar2(17);