APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PSTN_RT_F

Line 7266: -- START OF BEN_PSTN_RT_F ----------------------

7262: ---------------------------------------------------------------
7263: -- END OF BEN_JOB_RT_F ----------------------
7264: ---------------------------------------------------------------
7265: ---------------------------------------------------------------
7266: -- START OF BEN_PSTN_RT_F ----------------------
7267: ---------------------------------------------------------------
7268: cursor c_pst_from_parent(c_VRBL_RT_PRFL_ID number) is
7269: select pstn_rt_id
7270: from BEN_PSTN_RT_F

Line 7270: from BEN_PSTN_RT_F

7266: -- START OF BEN_PSTN_RT_F ----------------------
7267: ---------------------------------------------------------------
7268: cursor c_pst_from_parent(c_VRBL_RT_PRFL_ID number) is
7269: select pstn_rt_id
7270: from BEN_PSTN_RT_F
7271: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7272: --
7273: cursor c_pst(c_pstn_rt_id number,c_mirror_src_entity_result_id number,
7274: c_table_alias varchar2 ) is

Line 7276: from BEN_PSTN_RT_F pst

7272: --
7273: cursor c_pst(c_pstn_rt_id number,c_mirror_src_entity_result_id number,
7274: c_table_alias varchar2 ) is
7275: select pst.*
7276: from BEN_PSTN_RT_F pst
7277: where pst.pstn_rt_id = c_pstn_rt_id
7278: -- and pst.business_group_id = p_business_group_id
7279: and not exists (
7280: select /* */ null

Line 7287: -- and trt.where_clause = 'BEN_PSTN_RT_F'

7283: where copy_entity_txn_id = p_copy_entity_txn_id
7284: -- and trt.table_route_id = cpe.table_route_id
7285: and ( -- c_mirror_src_entity_result_id is null or
7286: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7287: -- and trt.where_clause = 'BEN_PSTN_RT_F'
7288: and cpe.table_alias = c_table_alias
7289: and information1 = c_pstn_rt_id
7290: -- and information4 = pst.business_group_id
7291: and information2 = pst.effective_start_date

Line 7311: -- END OF BEN_PSTN_RT_F ----------------------

7307: l_pstn_rt_id number(15);
7308: l_out_pst_result_id number(15);
7309: l_position_start_date per_positions.date_effective%type;
7310: ---------------------------------------------------------------
7311: -- END OF BEN_PSTN_RT_F ----------------------
7312: ---------------------------------------------------------------
7313: ---------------------------------------------------------------
7314: -- START OF BEN_QUAL_TITL_RT_F ----------------------
7315: ---------------------------------------------------------------

Line 12930: -- START OF BEN_PSTN_RT_F ----------------------

12926: -- END OF BEN_JOB_RT_F ----------------------
12927: ---------------------------------------------------------------
12928:
12929: ---------------------------------------------------------------
12930: -- START OF BEN_PSTN_RT_F ----------------------
12931: ---------------------------------------------------------------
12932: --
12933: hr_utility.set_location('START OF BEN_PSTN_RT_F ',100);
12934: for l_parent_rec in c_pst_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 12933: hr_utility.set_location('START OF BEN_PSTN_RT_F ',100);

12929: ---------------------------------------------------------------
12930: -- START OF BEN_PSTN_RT_F ----------------------
12931: ---------------------------------------------------------------
12932: --
12933: hr_utility.set_location('START OF BEN_PSTN_RT_F ',100);
12934: for l_parent_rec in c_pst_from_parent(l_VRBL_RT_PRFL_ID) loop
12935: --
12936: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
12937:

Line 13073: hr_utility.set_location('END OF BEN_PSTN_RT_F ',100);

13069: --
13070: end loop;
13071: --
13072: end loop;
13073: hr_utility.set_location('END OF BEN_PSTN_RT_F ',100);
13074: ---------------------------------------------------------------
13075: -- END OF BEN_PSTN_RT_F ----------------------
13076: ---------------------------------------------------------------
13077: ---------------------------------------------------------------

Line 13075: -- END OF BEN_PSTN_RT_F ----------------------

13071: --
13072: end loop;
13073: hr_utility.set_location('END OF BEN_PSTN_RT_F ',100);
13074: ---------------------------------------------------------------
13075: -- END OF BEN_PSTN_RT_F ----------------------
13076: ---------------------------------------------------------------
13077: ---------------------------------------------------------------
13078: -- START OF BEN_QUAL_TITL_RT_F ----------------------
13079: ---------------------------------------------------------------