APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_GRADE_RT_F

Line 6161: -- START OF BEN_GRADE_RT_F ----------------------

6157: ---------------------------------------------------------------
6158: -- END OF BEN_GNDR_RT_F ----------------------
6159: ---------------------------------------------------------------
6160: ---------------------------------------------------------------
6161: -- START OF BEN_GRADE_RT_F ----------------------
6162: ---------------------------------------------------------------
6163: cursor c_grr_from_parent(c_VRBL_RT_PRFL_ID number) is
6164: select grade_rt_id
6165: from BEN_GRADE_RT_F

Line 6165: from BEN_GRADE_RT_F

6161: -- START OF BEN_GRADE_RT_F ----------------------
6162: ---------------------------------------------------------------
6163: cursor c_grr_from_parent(c_VRBL_RT_PRFL_ID number) is
6164: select grade_rt_id
6165: from BEN_GRADE_RT_F
6166: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6167: --
6168: cursor c_grr(c_grade_rt_id number,c_mirror_src_entity_result_id number,
6169: c_table_alias varchar2 ) is

Line 6171: from BEN_GRADE_RT_F grr

6167: --
6168: cursor c_grr(c_grade_rt_id number,c_mirror_src_entity_result_id number,
6169: c_table_alias varchar2 ) is
6170: select grr.*
6171: from BEN_GRADE_RT_F grr
6172: where grr.grade_rt_id = c_grade_rt_id
6173: -- and grr.business_group_id = p_business_group_id
6174: and not exists (
6175: select /* */ null

Line 6182: -- and trt.where_clause = 'BEN_GRADE_RT_F'

6178: where copy_entity_txn_id = p_copy_entity_txn_id
6179: -- and trt.table_route_id = cpe.table_route_id
6180: and ( -- c_mirror_src_entity_result_id is null or
6181: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6182: -- and trt.where_clause = 'BEN_GRADE_RT_F'
6183: and cpe.table_alias = c_table_alias
6184: and information1 = c_grade_rt_id
6185: -- and information4 = grr.business_group_id
6186: and information2 = grr.effective_start_date

Line 6206: -- END OF BEN_GRADE_RT_F ----------------------

6202: where grade_id = c_grade_id;
6203:
6204: l_grade_start_date per_grades.date_from%type;
6205: ---------------------------------------------------------------
6206: -- END OF BEN_GRADE_RT_F ----------------------
6207: ---------------------------------------------------------------
6208: ---------------------------------------------------------------
6209: -- START OF BEN_HRLY_SLRD_RT_F ----------------------
6210: ---------------------------------------------------------------

Line 9487: -- START OF BEN_GRADE_RT_F ----------------------

9483: ---------------------------------------------------------------
9484: -- END OF BEN_GNDR_RT_F ----------------------
9485: ---------------------------------------------------------------
9486: ---------------------------------------------------------------
9487: -- START OF BEN_GRADE_RT_F ----------------------
9488: ---------------------------------------------------------------
9489: --
9490: hr_utility.set_location('START OF BEN_GRADE_RT_F',100);
9491: for l_parent_rec in c_grr_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 9490: hr_utility.set_location('START OF BEN_GRADE_RT_F',100);

9486: ---------------------------------------------------------------
9487: -- START OF BEN_GRADE_RT_F ----------------------
9488: ---------------------------------------------------------------
9489: --
9490: hr_utility.set_location('START OF BEN_GRADE_RT_F',100);
9491: for l_parent_rec in c_grr_from_parent(l_VRBL_RT_PRFL_ID) loop
9492: --
9493: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
9494:

Line 9629: hr_utility.set_location('END OF BEN_GRADE_RT_F',100);

9625: --
9626: end loop;
9627: --
9628: end loop;
9629: hr_utility.set_location('END OF BEN_GRADE_RT_F',100);
9630: ---------------------------------------------------------------
9631: -- END OF BEN_GRADE_RT_F ----------------------
9632: ---------------------------------------------------------------
9633: ---------------------------------------------------------------

Line 9631: -- END OF BEN_GRADE_RT_F ----------------------

9627: --
9628: end loop;
9629: hr_utility.set_location('END OF BEN_GRADE_RT_F',100);
9630: ---------------------------------------------------------------
9631: -- END OF BEN_GRADE_RT_F ----------------------
9632: ---------------------------------------------------------------
9633: ---------------------------------------------------------------
9634: -- START OF BEN_HRLY_SLRD_RT_F ----------------------
9635: ---------------------------------------------------------------