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.HR_RO_CONTACT_REL_VAL dependencies on PER_CONTACT_RELATIONSHIPS

Line 166: cursor cur_crl is select 1 from per_contact_relationships

162: ,p_person_id IN number
163: ,p_contact_type IN varchar2
164: ,p_person_type_id NUMBER) IS
165:
166: cursor cur_crl is select 1 from per_contact_relationships
167: where contact_person_id = p_contact_person_id
168: and person_id = p_person_id
169: and contact_type in ('EC','ES','PR1','PR2','OTH')
170: and P_CONTACT_TYPE in ('EC','ES','PR1','PR2','OTH')

Line 243: cursor cur_crl is select 1 from per_contact_relationships

239: ,p_date_start IN date
240: ,p_date_end IN date
241: ,p_contact_type IN varchar2) IS
242:
243: cursor cur_crl is select 1 from per_contact_relationships
244: where contact_person_id in
245: (select contact_person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
246: and person_id in (select person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
247: and contact_relationship_id <> p_contact_relationship_id

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

241: ,p_contact_type IN varchar2) IS
242:
243: cursor cur_crl is select 1 from per_contact_relationships
244: where contact_person_id in
245: (select contact_person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
246: and person_id in (select person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
247: and contact_relationship_id <> p_contact_relationship_id
248: and contact_type in ('EC','ES','PR1','PR2','OTH')
249: and P_CONTACT_TYPE in ('EC','ES','PR1','PR2','OTH')

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

242:
243: cursor cur_crl is select 1 from per_contact_relationships
244: where contact_person_id in
245: (select contact_person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
246: and person_id in (select person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
247: and contact_relationship_id <> p_contact_relationship_id
248: and contact_type in ('EC','ES','PR1','PR2','OTH')
249: and P_CONTACT_TYPE in ('EC','ES','PR1','PR2','OTH')
250: and (date_start >= p_date_start

Line 255: per_contact_relationships where contact_relationship_id = P_CONTACT_RELATIONSHIP_ID);

251: OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));
252:
253: cursor csr_dob_contact is
254: select date_of_birth from per_all_people_f where person_id in (select contact_person_id from
255: per_contact_relationships where contact_relationship_id = P_CONTACT_RELATIONSHIP_ID);
256:
257: /* cursor csr_person_type is
258: select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/
259: