APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 9177: -- START OF BEN_PER_INFO_CHG_CS_LER_F ----------------------

9173: ---------------------------------------------------------------
9174: -- END OF BEN_LER_RLTD_PER_CS_LER_F ----------------------
9175: ---------------------------------------------------------------
9176: ---------------------------------------------------------------
9177: -- START OF BEN_PER_INFO_CHG_CS_LER_F ----------------------
9178: ---------------------------------------------------------------
9179: cursor c_psl_from_parent(c_LER_PER_INFO_CS_LER_ID number) is
9180: select psl.per_info_chg_cs_ler_id
9181: from BEN_LER_PER_INFO_CS_LER_F lpl,

Line 9182: BEN_PER_INFO_CHG_CS_LER_F psl

9178: ---------------------------------------------------------------
9179: cursor c_psl_from_parent(c_LER_PER_INFO_CS_LER_ID number) is
9180: select psl.per_info_chg_cs_ler_id
9181: from BEN_LER_PER_INFO_CS_LER_F lpl,
9182: BEN_PER_INFO_CHG_CS_LER_F psl
9183: where LER_PER_INFO_CS_LER_ID = c_LER_PER_INFO_CS_LER_ID
9184: and psl.PER_INFO_CHG_CS_LER_id = lpl.PER_INFO_CHG_CS_LER_id
9185: and source_table = 'PER_ABSENCE_ATTENDANCES';
9186: --

Line 9189: from BEN_PER_INFO_CHG_CS_LER_F psl

9185: and source_table = 'PER_ABSENCE_ATTENDANCES';
9186: --
9187: cursor c_psl(c_per_info_chg_cs_ler_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
9188: select psl.*
9189: from BEN_PER_INFO_CHG_CS_LER_F psl
9190: where psl.per_info_chg_cs_ler_id = c_per_info_chg_cs_ler_id
9191: -- and psl.business_group_id = p_business_group_id
9192: and not exists (
9193: select /*+ */ null

Line 9200: -- and trt.where_clause = 'BEN_PER_INFO_CHG_CS_LER_F'

9196: where copy_entity_txn_id = p_copy_entity_txn_id
9197: -- and trt.table_route_id = cpe.table_route_id
9198: and ( -- c_mirror_src_entity_result_id is null or
9199: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9200: -- and trt.where_clause = 'BEN_PER_INFO_CHG_CS_LER_F'
9201: and cpe.table_alias = c_table_alias
9202: and information1 = c_per_info_chg_cs_ler_id
9203: -- and information4 = psl.business_group_id
9204: and information2 = psl.effective_start_date

Line 9230: -- END OF BEN_PER_INFO_CHG_CS_LER_F ----------------------

9226: l_abs_old_name varchar2(600);
9227: l_abs_new_name varchar2(600);
9228: l_out_psl_result_id number(15);
9229: ---------------------------------------------------------------
9230: -- END OF BEN_PER_INFO_CHG_CS_LER_F ----------------------
9231: ---------------------------------------------------------------
9232: ---------------------------------------------------------------
9233: -- START OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------
9234: ---------------------------------------------------------------

Line 9653: -- START OF BEN_PER_INFO_CHG_CS_LER_F ----------------------

9649: --
9650: end loop;
9651: --
9652: ---------------------------------------------------------------
9653: -- START OF BEN_PER_INFO_CHG_CS_LER_F ----------------------
9654: ---------------------------------------------------------------
9655: --
9656: for l_parent_rec in c_psl_from_parent(l_LER_PER_INFO_CS_LER_ID) loop
9657: --

Line 9810: -- END OF BEN_PER_INFO_CHG_CS_LER_F ----------------------

9806: end loop;
9807: --
9808: end loop;
9809: ---------------------------------------------------------------
9810: -- END OF BEN_PER_INFO_CHG_CS_LER_F ----------------------
9811: ---------------------------------------------------------------
9812: end loop;
9813: ---------------------------------------------------------------
9814: -- END OF BEN_LER_PER_INFO_CS_LER_F ----------------------