APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ASNT_SET_RT_F

Line 5792: -- START OF BEN_ASNT_SET_RT_F ----------------------

5788: ---------------------------------------------------------------
5789: -- END OF BEN_AGE_RT_F ----------------------
5790: ---------------------------------------------------------------
5791: ---------------------------------------------------------------
5792: -- START OF BEN_ASNT_SET_RT_F ----------------------
5793: ---------------------------------------------------------------
5794: cursor c_asr_from_parent(c_VRBL_RT_PRFL_ID number) is
5795: select asnt_set_rt_id
5796: from BEN_ASNT_SET_RT_F

Line 5796: from BEN_ASNT_SET_RT_F

5792: -- START OF BEN_ASNT_SET_RT_F ----------------------
5793: ---------------------------------------------------------------
5794: cursor c_asr_from_parent(c_VRBL_RT_PRFL_ID number) is
5795: select asnt_set_rt_id
5796: from BEN_ASNT_SET_RT_F
5797: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
5798: --
5799: cursor c_asr(c_asnt_set_rt_id number,c_mirror_src_entity_result_id number,
5800: c_table_alias varchar2 ) is

Line 5802: from BEN_ASNT_SET_RT_F asr

5798: --
5799: cursor c_asr(c_asnt_set_rt_id number,c_mirror_src_entity_result_id number,
5800: c_table_alias varchar2 ) is
5801: select asr.*
5802: from BEN_ASNT_SET_RT_F asr
5803: where asr.asnt_set_rt_id = c_asnt_set_rt_id
5804: -- and asr.business_group_id = p_business_group_id
5805: and not exists (
5806: select /* */ null

Line 5813: -- and trt.where_clause = 'BEN_ASNT_SET_RT_F'

5809: where copy_entity_txn_id = p_copy_entity_txn_id
5810: -- and trt.table_route_id = cpe.table_route_id
5811: and ( -- c_mirror_src_entity_result_id is null or
5812: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5813: -- and trt.where_clause = 'BEN_ASNT_SET_RT_F'
5814: and cpe.table_alias = c_table_alias
5815: and information1 = c_asnt_set_rt_id
5816: -- and information4 = asr.business_group_id
5817: and information2 = asr.effective_start_date

Line 5831: -- END OF BEN_ASNT_SET_RT_F ----------------------

5827: where business_group_id = p_business_group_id
5828: and assignment_set_id = p_id;
5829: --
5830: ---------------------------------------------------------------
5831: -- END OF BEN_ASNT_SET_RT_F ----------------------
5832: ---------------------------------------------------------------
5833: ---------------------------------------------------------------
5834: -- START OF BEN_BENFTS_GRP_RT_F ----------------------
5835: ---------------------------------------------------------------

Line 8439: -- START OF BEN_ASNT_SET_RT_F ----------------------

8435: ---------------------------------------------------------------
8436: -- END OF BEN_AGE_RT_F ----------------------
8437: ---------------------------------------------------------------
8438: ---------------------------------------------------------------
8439: -- START OF BEN_ASNT_SET_RT_F ----------------------
8440: ---------------------------------------------------------------
8441: --
8442: hr_utility.set_location('START OF BEN_ASNT_SET_RT_F ',100);
8443: --

Line 8442: hr_utility.set_location('START OF BEN_ASNT_SET_RT_F ',100);

8438: ---------------------------------------------------------------
8439: -- START OF BEN_ASNT_SET_RT_F ----------------------
8440: ---------------------------------------------------------------
8441: --
8442: hr_utility.set_location('START OF BEN_ASNT_SET_RT_F ',100);
8443: --
8444: for l_parent_rec in c_asr_from_parent(l_VRBL_RT_PRFL_ID) loop
8445: --
8446: l_mirror_src_entity_result_id := l_out_vpf_result_id ;

Line 8572: hr_utility.set_location('END OF BEN_ASNT_SET_RT_F ',100);

8568: --
8569: end loop;
8570: --
8571: end loop;
8572: hr_utility.set_location('END OF BEN_ASNT_SET_RT_F ',100);
8573: ---------------------------------------------------------------
8574: -- END OF BEN_ASNT_SET_RT_F ----------------------
8575: ---------------------------------------------------------------
8576: ---------------------------------------------------------------

Line 8574: -- END OF BEN_ASNT_SET_RT_F ----------------------

8570: --
8571: end loop;
8572: hr_utility.set_location('END OF BEN_ASNT_SET_RT_F ',100);
8573: ---------------------------------------------------------------
8574: -- END OF BEN_ASNT_SET_RT_F ----------------------
8575: ---------------------------------------------------------------
8576: ---------------------------------------------------------------
8577: -- START OF BEN_BENFTS_GRP_RT_F ----------------------
8578: ---------------------------------------------------------------