DBA Data[Home] [Help]

APPS.BEN_PLAN_BENEFICIARY_API dependencies on PER_PERSON_TYPES

Line 1755: from per_person_types

1751: --
1752: --
1753: cursor get_bnf_type_id_c is
1754: select person_type_id
1755: from per_person_types
1756: where system_person_type = 'BNF'
1757: and business_group_id = p_business_group_id;
1758: --
1759: cursor get_enrt_cvg_strt_dt_c is

Line 1940: per_person_types b

1936: a.effective_end_date
1937: -- bug 5668052
1938: ,a.effective_start_date
1939: from per_person_type_usages_f a,
1940: per_person_types b
1941: where a.person_id = l_bnf_person_id
1942: and a.person_type_id = b.person_type_id
1943: and b.system_person_type = 'BNF'
1944: and b.business_group_id = l_business_group_id