APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PER_TYP_RT_F

Line 6615: -- START OF BEN_PER_TYP_RT_F ----------------------

6611: ---------------------------------------------------------------
6612: -- END OF BEN_PCT_FL_TM_RT_F ----------------------
6613: ---------------------------------------------------------------
6614: ---------------------------------------------------------------
6615: -- START OF BEN_PER_TYP_RT_F ----------------------
6616: ---------------------------------------------------------------
6617: cursor c_ptr_from_parent(c_VRBL_RT_PRFL_ID number) is
6618: select per_typ_rt_id
6619: from BEN_PER_TYP_RT_F

Line 6619: from BEN_PER_TYP_RT_F

6615: -- START OF BEN_PER_TYP_RT_F ----------------------
6616: ---------------------------------------------------------------
6617: cursor c_ptr_from_parent(c_VRBL_RT_PRFL_ID number) is
6618: select per_typ_rt_id
6619: from BEN_PER_TYP_RT_F
6620: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6621: --
6622: cursor c_ptr(c_per_typ_rt_id number,c_mirror_src_entity_result_id number,
6623: c_table_alias varchar2 ) is

Line 6625: from BEN_PER_TYP_RT_F ptr

6621: --
6622: cursor c_ptr(c_per_typ_rt_id number,c_mirror_src_entity_result_id number,
6623: c_table_alias varchar2 ) is
6624: select ptr.*
6625: from BEN_PER_TYP_RT_F ptr
6626: where ptr.per_typ_rt_id = c_per_typ_rt_id
6627: -- and ptr.business_group_id = p_business_group_id
6628: and not exists (
6629: select /* */ null

Line 6636: -- and trt.where_clause = 'BEN_PER_TYP_RT_F'

6632: where copy_entity_txn_id = p_copy_entity_txn_id
6633: -- and trt.table_route_id = cpe.table_route_id
6634: and ( -- c_mirror_src_entity_result_id is null or
6635: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6636: -- and trt.where_clause = 'BEN_PER_TYP_RT_F'
6637: and cpe.table_alias = c_table_alias
6638: and information1 = c_per_typ_rt_id
6639: -- and information4 = ptr.business_group_id
6640: and information2 = ptr.effective_start_date

Line 6665: -- END OF BEN_PER_TYP_RT_F ----------------------

6661: l_mapping_person_type_id number;
6662: l_mapping_person_type_name varchar2(600);
6663: --
6664: ---------------------------------------------------------------
6665: -- END OF BEN_PER_TYP_RT_F ----------------------
6666: ---------------------------------------------------------------
6667: ---------------------------------------------------------------
6668: -- START OF BEN_POE_RT_F ----------------------
6669: ---------------------------------------------------------------

Line 10779: -- START OF BEN_PER_TYP_RT_F ----------------------

10775: ---------------------------------------------------------------
10776: -- END OF BEN_PCT_FL_TM_RT_F ----------------------
10777: ---------------------------------------------------------------
10778: ---------------------------------------------------------------
10779: -- START OF BEN_PER_TYP_RT_F ----------------------
10780: ---------------------------------------------------------------
10781: --
10782: hr_utility.set_location('START OF BEN_PER_TYP_RT_F ',100);
10783: for l_parent_rec in c_ptr_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 10782: hr_utility.set_location('START OF BEN_PER_TYP_RT_F ',100);

10778: ---------------------------------------------------------------
10779: -- START OF BEN_PER_TYP_RT_F ----------------------
10780: ---------------------------------------------------------------
10781: --
10782: hr_utility.set_location('START OF BEN_PER_TYP_RT_F ',100);
10783: for l_parent_rec in c_ptr_from_parent(l_VRBL_RT_PRFL_ID) loop
10784: --
10785: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
10786:

Line 10913: hr_utility.set_location('END OF BEN_PER_TYP_RT_F ',100);

10909: --
10910: end loop;
10911: --
10912: end loop;
10913: hr_utility.set_location('END OF BEN_PER_TYP_RT_F ',100);
10914: ---------------------------------------------------------------
10915: -- END OF BEN_PER_TYP_RT_F ----------------------
10916: ---------------------------------------------------------------
10917: ---------------------------------------------------------------

Line 10915: -- END OF BEN_PER_TYP_RT_F ----------------------

10911: --
10912: end loop;
10913: hr_utility.set_location('END OF BEN_PER_TYP_RT_F ',100);
10914: ---------------------------------------------------------------
10915: -- END OF BEN_PER_TYP_RT_F ----------------------
10916: ---------------------------------------------------------------
10917: ---------------------------------------------------------------
10918: -- START OF BEN_POE_RT_F ----------------------
10919: ---------------------------------------------------------------