APPS.BEN_PEN_BUS dependencies on PER_PERSON_TYPE_USAGES_F

Line 2582: l_person_type_id per_person_type_usages_f.person_type_id%type:=null;

2578: and sspndd_flag = 'N'
2579: and effective_end_date = hr_api.g_eot -- Bug 2130842 added this clause
2580: order by 1 asc, 2 desc;
2581: --
2582: l_person_type_id per_person_type_usages_f.person_type_id%type:=null;
2583: --
2584: cursor c_ptu is
2585: select a.person_type_usage_id
2586: ,a.person_type_id

Line 2591: from per_person_type_usages_f a

2587: ,a.effective_start_date ESD
2588: ,a.effective_end_date EED
2589: ,a.object_version_number OVN
2590: ,'N' Match
2591: from per_person_type_usages_f a
2592: where a.Person_id = p_person_id
2593: and a.person_type_id = l_person_type_id
2594: order by a.effective_start_date asc, a.effective_end_date desc;
2595: --

Line 2606: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%type;

2602: type pen_record is table of c_pen%rowtype index by binary_integer;
2603: type ptu_record is table of c_ptu%rowtype index by binary_integer;
2604: l_pen pen_record;
2605: l_ptu ptu_record;
2606: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%type;
2607: l_object_version_number per_person_type_usages_f.object_version_number%type;
2608: l_esd per_person_type_usages_f.effective_start_date%type;
2609: l_eed per_person_type_usages_f.effective_end_date%type;
2610: l_next_ptu number:=1;

Line 2607: l_object_version_number per_person_type_usages_f.object_version_number%type;

2603: type ptu_record is table of c_ptu%rowtype index by binary_integer;
2604: l_pen pen_record;
2605: l_ptu ptu_record;
2606: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%type;
2607: l_object_version_number per_person_type_usages_f.object_version_number%type;
2608: l_esd per_person_type_usages_f.effective_start_date%type;
2609: l_eed per_person_type_usages_f.effective_end_date%type;
2610: l_next_ptu number:=1;
2611: l_next_pen number:=1;

Line 2608: l_esd per_person_type_usages_f.effective_start_date%type;

2604: l_pen pen_record;
2605: l_ptu ptu_record;
2606: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%type;
2607: l_object_version_number per_person_type_usages_f.object_version_number%type;
2608: l_esd per_person_type_usages_f.effective_start_date%type;
2609: l_eed per_person_type_usages_f.effective_end_date%type;
2610: l_next_ptu number:=1;
2611: l_next_pen number:=1;
2612: --

Line 2609: l_eed per_person_type_usages_f.effective_end_date%type;

2605: l_ptu ptu_record;
2606: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%type;
2607: l_object_version_number per_person_type_usages_f.object_version_number%type;
2608: l_esd per_person_type_usages_f.effective_start_date%type;
2609: l_eed per_person_type_usages_f.effective_end_date%type;
2610: l_next_ptu number:=1;
2611: l_next_pen number:=1;
2612: --
2613: e_no_pt exception;