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

Line 1658: from per_contact_relationships ctr

1654: and pet.system_person_type = 'PRTN';
1655: --
1656: cursor c_get_contact_type is
1657: select null
1658: from per_contact_relationships ctr
1659: where ctr.person_id = p_person_id
1660: and ctr.contact_type = 'S'
1661: and p_lf_evt_ocrd_dt
1662: between nvl(ctr.date_start,hr_api.g_sot) and

Line 2544: from per_contact_relationships ctr

2540: and pet.system_person_type = 'PRTN';
2541: --
2542: cursor c_get_cvrd_emp is
2543: select ctr.person_id
2544: from per_contact_relationships ctr
2545: ,per_person_type_usages_f ptu
2546: ,per_person_types pet
2547: where ctr.contact_person_id = p_person_id
2548: and p_lf_evt_ocrd_dt

Line 2692: from per_contact_relationships ctr

2688: ;
2689: --
2690: cursor c_get_emp_person_id is
2691: select ctr.person_id
2692: from per_contact_relationships ctr
2693: where ctr.contact_person_id = p_person_id
2694: and p_lf_evt_ocrd_dt
2695: between nvl(ctr.date_start,hr_api.g_sot) and
2696: nvl(ctr.date_end,hr_api.g_eot)