APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_LOA_RSN_RT_F

Line 6374: -- START OF BEN_LOA_RSN_RT_F ----------------------

6370: ---------------------------------------------------------------
6371: -- END OF BEN_LGL_ENTY_RT_F ----------------------
6372: ---------------------------------------------------------------
6373: ---------------------------------------------------------------
6374: -- START OF BEN_LOA_RSN_RT_F ----------------------
6375: ---------------------------------------------------------------
6376: cursor c_lar_from_parent(c_VRBL_RT_PRFL_ID number) is
6377: select loa_rsn_rt_id
6378: from BEN_LOA_RSN_RT_F

Line 6378: from BEN_LOA_RSN_RT_F

6374: -- START OF BEN_LOA_RSN_RT_F ----------------------
6375: ---------------------------------------------------------------
6376: cursor c_lar_from_parent(c_VRBL_RT_PRFL_ID number) is
6377: select loa_rsn_rt_id
6378: from BEN_LOA_RSN_RT_F
6379: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6380: --
6381: cursor c_lar(c_loa_rsn_rt_id number,c_mirror_src_entity_result_id number,
6382: c_table_alias varchar2 ) is

Line 6384: from BEN_LOA_RSN_RT_F lar

6380: --
6381: cursor c_lar(c_loa_rsn_rt_id number,c_mirror_src_entity_result_id number,
6382: c_table_alias varchar2 ) is
6383: select lar.*
6384: from BEN_LOA_RSN_RT_F lar
6385: where lar.loa_rsn_rt_id = c_loa_rsn_rt_id
6386: -- and lar.business_group_id = p_business_group_id
6387: and not exists (
6388: select /* */ null

Line 6395: -- and trt.where_clause = 'BEN_LOA_RSN_RT_F'

6391: where copy_entity_txn_id = p_copy_entity_txn_id
6392: -- and trt.table_route_id = cpe.table_route_id
6393: and ( -- c_mirror_src_entity_result_id is null or
6394: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6395: -- and trt.where_clause = 'BEN_LOA_RSN_RT_F'
6396: and cpe.table_alias = c_table_alias
6397: and information1 = c_loa_rsn_rt_id
6398: -- and information4 = lar.business_group_id
6399: and information2 = lar.effective_start_date

Line 6438: -- END OF BEN_LOA_RSN_RT_F ----------------------

6434: where absence_attendance_type_id = c_absence_attendance_type_id;
6435:
6436: l_absence_type_start_date per_absence_attendance_types.date_effective%type;
6437: ---------------------------------------------------------------
6438: -- END OF BEN_LOA_RSN_RT_F ----------------------
6439: ---------------------------------------------------------------
6440: ---------------------------------------------------------------
6441: -- START OF BEN_LOS_RT_F ----------------------
6442: ---------------------------------------------------------------

Line 10115: -- START OF BEN_LOA_RSN_RT_F ----------------------

10111: ---------------------------------------------------------------
10112: -- END OF BEN_LGL_ENTY_RT_F ----------------------
10113: ---------------------------------------------------------------
10114: ---------------------------------------------------------------
10115: -- START OF BEN_LOA_RSN_RT_F ----------------------
10116: ---------------------------------------------------------------
10117: --
10118: hr_utility.set_location('START OF BEN_LOA_RSN_RT_F ',100);
10119: for l_parent_rec in c_lar_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 10118: hr_utility.set_location('START OF BEN_LOA_RSN_RT_F ',100);

10114: ---------------------------------------------------------------
10115: -- START OF BEN_LOA_RSN_RT_F ----------------------
10116: ---------------------------------------------------------------
10117: --
10118: hr_utility.set_location('START OF BEN_LOA_RSN_RT_F ',100);
10119: for l_parent_rec in c_lar_from_parent(l_VRBL_RT_PRFL_ID) loop
10120: --
10121: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
10122:

Line 10282: hr_utility.set_location('END OF BEN_LOA_RSN_RT_F ',100);

10278: --
10279: end loop;
10280: --
10281: end loop;
10282: hr_utility.set_location('END OF BEN_LOA_RSN_RT_F ',100);
10283: ---------------------------------------------------------------
10284: -- END OF BEN_LOA_RSN_RT_F ----------------------
10285: ---------------------------------------------------------------
10286: ---------------------------------------------------------------

Line 10284: -- END OF BEN_LOA_RSN_RT_F ----------------------

10280: --
10281: end loop;
10282: hr_utility.set_location('END OF BEN_LOA_RSN_RT_F ',100);
10283: ---------------------------------------------------------------
10284: -- END OF BEN_LOA_RSN_RT_F ----------------------
10285: ---------------------------------------------------------------
10286: ---------------------------------------------------------------
10287: -- START OF BEN_LOS_RT_F ----------------------
10288: ---------------------------------------------------------------