APPS.BEN_COBRA_REQUIREMENTS dependencies on PER_PERSON_TYPE_USAGES_F

Line 1641: l_effective_date per_person_type_usages_f.effective_start_date%type;

1637: ,p_lf_evt_ocrd_dt in date
1638: ,p_business_group_id in number) return boolean is
1639: --
1640: --
1641: l_effective_date per_person_type_usages_f.effective_start_date%type;
1642: l_eligible boolean := false;
1643: l_exists varchar2(1);
1644: l_proc varchar2(80) := g_package||'.check_max_poe_eligibility';
1645: --

Line 1648: from per_person_type_usages_f ptu

1644: l_proc varchar2(80) := g_package||'.check_max_poe_eligibility';
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

Line 2534: from per_person_type_usages_f ptu

2530: l_object_version_number ben_cbr_quald_bnf.object_version_number%type;
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

Line 2545: ,per_person_type_usages_f ptu

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