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 1563: ,per_person_types pet

1559: --
1560: cursor c_chk_cvrd_emp is
1561: select null
1562: from per_person_type_usages_f ptu
1563: ,per_person_types pet
1564: where ptu.person_type_id = pet.person_type_id
1565: and ptu.person_id = p_person_id
1566: and l_effective_date between
1567: ptu.effective_start_date and ptu.effective_end_date

Line 2355: ,per_person_types pet

2351: --
2352: cursor c_chk_cvrd_emp is
2353: select null
2354: from per_person_type_usages_f ptu
2355: ,per_person_types pet
2356: where ptu.person_type_id = pet.person_type_id
2357: and ptu.person_id = p_person_id
2358: and l_effective_date between
2359: ptu.effective_start_date and ptu.effective_end_date

Line 2366: ,per_person_types pet

2362: cursor c_get_cvrd_emp is
2363: select ctr.person_id
2364: from per_contact_relationships ctr
2365: ,per_person_type_usages_f ptu
2366: ,per_person_types pet
2367: where ctr.contact_person_id = p_person_id
2368: and p_lf_evt_ocrd_dt
2369: between nvl(ctr.date_start,hr_api.g_sot) and
2370: nvl(ctr.date_end,hr_api.g_eot)