DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_LGL_ENTY_RT_F

Line 6320: -- START OF BEN_LGL_ENTY_RT_F ----------------------

6316: ---------------------------------------------------------------
6317: -- END OF BEN_LBR_MMBR_RT_F ----------------------
6318: ---------------------------------------------------------------
6319: ---------------------------------------------------------------
6320: -- START OF BEN_LGL_ENTY_RT_F ----------------------
6321: ---------------------------------------------------------------
6322: cursor c_ler_from_parent(c_VRBL_RT_PRFL_ID number) is
6323: select lgl_enty_rt_id
6324: from BEN_LGL_ENTY_RT_F

Line 6324: from BEN_LGL_ENTY_RT_F

6320: -- START OF BEN_LGL_ENTY_RT_F ----------------------
6321: ---------------------------------------------------------------
6322: cursor c_ler_from_parent(c_VRBL_RT_PRFL_ID number) is
6323: select lgl_enty_rt_id
6324: from BEN_LGL_ENTY_RT_F
6325: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6326: --
6327: cursor c_ler(c_lgl_enty_rt_id number,c_mirror_src_entity_result_id number,
6328: c_table_alias varchar2 ) is

Line 6330: from BEN_LGL_ENTY_RT_F ler

6326: --
6327: cursor c_ler(c_lgl_enty_rt_id number,c_mirror_src_entity_result_id number,
6328: c_table_alias varchar2 ) is
6329: select ler.*
6330: from BEN_LGL_ENTY_RT_F ler
6331: where ler.lgl_enty_rt_id = c_lgl_enty_rt_id
6332: -- and ler.business_group_id = p_business_group_id
6333: and not exists (
6334: select /* */ null

Line 6341: -- and trt.where_clause = 'BEN_LGL_ENTY_RT_F'

6337: where copy_entity_txn_id = p_copy_entity_txn_id
6338: -- and trt.table_route_id = cpe.table_route_id
6339: and ( -- c_mirror_src_entity_result_id is null or
6340: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6341: -- and trt.where_clause = 'BEN_LGL_ENTY_RT_F'
6342: and cpe.table_alias = c_table_alias
6343: and information1 = c_lgl_enty_rt_id
6344: -- and information4 = ler.business_group_id
6345: and information2 = ler.effective_start_date

Line 6371: -- END OF BEN_LGL_ENTY_RT_F ----------------------

6367: where organization_id = c_organization_id;
6368:
6369: l_organization_start_date hr_all_organization_units.date_from%type;
6370: ---------------------------------------------------------------
6371: -- END OF BEN_LGL_ENTY_RT_F ----------------------
6372: ---------------------------------------------------------------
6373: ---------------------------------------------------------------
6374: -- START OF BEN_LOA_RSN_RT_F ----------------------
6375: ---------------------------------------------------------------

Line 9963: -- START OF BEN_LGL_ENTY_RT_F ----------------------

9959: ---------------------------------------------------------------
9960: -- END OF BEN_LBR_MMBR_RT_F ----------------------
9961: ---------------------------------------------------------------
9962: ---------------------------------------------------------------
9963: -- START OF BEN_LGL_ENTY_RT_F ----------------------
9964: ---------------------------------------------------------------
9965: --
9966: hr_utility.set_location('START OF BEN_LGL_ENTY_RT_F ',100);
9967: for l_parent_rec in c_ler_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 9966: hr_utility.set_location('START OF BEN_LGL_ENTY_RT_F ',100);

9962: ---------------------------------------------------------------
9963: -- START OF BEN_LGL_ENTY_RT_F ----------------------
9964: ---------------------------------------------------------------
9965: --
9966: hr_utility.set_location('START OF BEN_LGL_ENTY_RT_F ',100);
9967: for l_parent_rec in c_ler_from_parent(l_VRBL_RT_PRFL_ID) loop
9968: --
9969: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
9970:

Line 10110: hr_utility.set_location('END OF BEN_LGL_ENTY_RT_F ',100);

10106: --
10107: end loop;
10108: --
10109: end loop;
10110: hr_utility.set_location('END OF BEN_LGL_ENTY_RT_F ',100);
10111: ---------------------------------------------------------------
10112: -- END OF BEN_LGL_ENTY_RT_F ----------------------
10113: ---------------------------------------------------------------
10114: ---------------------------------------------------------------

Line 10112: -- END OF BEN_LGL_ENTY_RT_F ----------------------

10108: --
10109: end loop;
10110: hr_utility.set_location('END OF BEN_LGL_ENTY_RT_F ',100);
10111: ---------------------------------------------------------------
10112: -- END OF BEN_LGL_ENTY_RT_F ----------------------
10113: ---------------------------------------------------------------
10114: ---------------------------------------------------------------
10115: -- START OF BEN_LOA_RSN_RT_F ----------------------
10116: ---------------------------------------------------------------