DBA Data[Home] [Help]

APPS.BEN_EXT_EVALUATE_INCLUSION dependencies on PER_PERSON_TYPE_USAGES_F

Line 2448: FROM per_person_type_usages_f ptu

2444: is
2445: --
2446: cursor get_person_type is
2447: SELECT person_type_id
2448: FROM per_person_type_usages_f ptu
2449: WHERE ptu.person_id = p_person_id
2450: AND p_effective_date between ptu.effective_start_date and
2451: ptu.effective_end_date;
2452: --

Line 2453: l_person_type_id per_person_type_usages_f.person_type_id%type;

2449: WHERE ptu.person_id = p_person_id
2450: AND p_effective_date between ptu.effective_start_date and
2451: ptu.effective_end_date;
2452: --
2453: l_person_type_id per_person_type_usages_f.person_type_id%type;
2454: --
2455: l_proc varchar2(72);
2456: --
2457: Begin