DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_HRLY_SLRD_RT_F

Line 6209: -- START OF BEN_HRLY_SLRD_RT_F ----------------------

6205: ---------------------------------------------------------------
6206: -- END OF BEN_GRADE_RT_F ----------------------
6207: ---------------------------------------------------------------
6208: ---------------------------------------------------------------
6209: -- START OF BEN_HRLY_SLRD_RT_F ----------------------
6210: ---------------------------------------------------------------
6211: cursor c_hsr_from_parent(c_VRBL_RT_PRFL_ID number) is
6212: select hrly_slrd_rt_id
6213: from BEN_HRLY_SLRD_RT_F

Line 6213: from BEN_HRLY_SLRD_RT_F

6209: -- START OF BEN_HRLY_SLRD_RT_F ----------------------
6210: ---------------------------------------------------------------
6211: cursor c_hsr_from_parent(c_VRBL_RT_PRFL_ID number) is
6212: select hrly_slrd_rt_id
6213: from BEN_HRLY_SLRD_RT_F
6214: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6215: --
6216: cursor c_hsr(c_hrly_slrd_rt_id number,c_mirror_src_entity_result_id number,
6217: c_table_alias varchar2 ) is

Line 6219: from BEN_HRLY_SLRD_RT_F hsr

6215: --
6216: cursor c_hsr(c_hrly_slrd_rt_id number,c_mirror_src_entity_result_id number,
6217: c_table_alias varchar2 ) is
6218: select hsr.*
6219: from BEN_HRLY_SLRD_RT_F hsr
6220: where hsr.hrly_slrd_rt_id = c_hrly_slrd_rt_id
6221: -- and hsr.business_group_id = p_business_group_id
6222: and not exists (
6223: select /* */ null

Line 6230: -- and trt.where_clause = 'BEN_HRLY_SLRD_RT_F'

6226: where copy_entity_txn_id = p_copy_entity_txn_id
6227: -- and trt.table_route_id = cpe.table_route_id
6228: and ( -- c_mirror_src_entity_result_id is null or
6229: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6230: -- and trt.where_clause = 'BEN_HRLY_SLRD_RT_F'
6231: and cpe.table_alias = c_table_alias
6232: and information1 = c_hrly_slrd_rt_id
6233: -- and information4 = hsr.business_group_id
6234: and information2 = hsr.effective_start_date

Line 6239: -- END OF BEN_HRLY_SLRD_RT_F ----------------------

6235: and information3 = hsr.effective_end_date);
6236: l_hrly_slrd_rt_id number(15);
6237: l_out_hsr_result_id number(15);
6238: ---------------------------------------------------------------
6239: -- END OF BEN_HRLY_SLRD_RT_F ----------------------
6240: ---------------------------------------------------------------
6241: ---------------------------------------------------------------
6242: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
6243: ---------------------------------------------------------------

Line 9634: -- START OF BEN_HRLY_SLRD_RT_F ----------------------

9630: ---------------------------------------------------------------
9631: -- END OF BEN_GRADE_RT_F ----------------------
9632: ---------------------------------------------------------------
9633: ---------------------------------------------------------------
9634: -- START OF BEN_HRLY_SLRD_RT_F ----------------------
9635: ---------------------------------------------------------------
9636: --
9637: for l_parent_rec in c_hsr_from_parent(l_VRBL_RT_PRFL_ID) loop
9638: --

Line 9732: -- END OF BEN_HRLY_SLRD_RT_F ----------------------

9728: end loop;
9729: --
9730: end loop;
9731: ---------------------------------------------------------------
9732: -- END OF BEN_HRLY_SLRD_RT_F ----------------------
9733: ---------------------------------------------------------------
9734: ---------------------------------------------------------------
9735: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
9736: ---------------------------------------------------------------