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_PERSON_TYPES

Line 1649: ,per_person_types pet

1645: --
1646: cursor c_chk_cvrd_emp is
1647: select null
1648: from per_person_type_usages_f ptu
1649: ,per_person_types pet
1650: where ptu.person_type_id = pet.person_type_id
1651: and ptu.person_id = p_person_id
1652: and l_effective_date between
1653: ptu.effective_start_date and ptu.effective_end_date

Line 2535: ,per_person_types pet

2531: --
2532: cursor c_chk_cvrd_emp is
2533: select null
2534: from per_person_type_usages_f ptu
2535: ,per_person_types pet
2536: where ptu.person_type_id = pet.person_type_id
2537: and ptu.person_id = p_person_id
2538: and l_effective_date between
2539: ptu.effective_start_date and ptu.effective_end_date

Line 2546: ,per_person_types pet

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
2549: between nvl(ctr.date_start,hr_api.g_sot) and
2550: nvl(ctr.date_end,hr_api.g_eot)