APPS.BEN_COBRA_REQUIREMENTS dependencies on PER_PERSON_TYPE_USAGES_F

Line 1555: l_effective_date per_person_type_usages_f.effective_start_date%type;

1551: ,p_lf_evt_ocrd_dt in date
1552: ,p_business_group_id in number) return boolean is
1553: --
1554: --
1555: l_effective_date per_person_type_usages_f.effective_start_date%type;
1556: l_eligible boolean := false;
1557: l_exists varchar2(1);
1558: l_proc varchar2(80) := g_package||'.check_max_poe_eligibility';
1559: --

Line 1562: from per_person_type_usages_f ptu

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

Line 2354: from per_person_type_usages_f ptu

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

Line 2365: ,per_person_type_usages_f ptu

2361: --
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