eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_COMPTNCY_RT_F

Line 7160: -- START OF BEN_COMPTNCY_RT_F ----------------------

7156: ---------------------------------------------------------------
7157: -- END OF BEN_WK_LOC_RT_F ----------------------
7158: ---------------------------------------------------------------
7159: ---------------------------------------------------------------
7160: -- START OF BEN_COMPTNCY_RT_F ----------------------
7161: ---------------------------------------------------------------
7162: cursor c_cty_from_parent(c_VRBL_RT_PRFL_ID number) is
7163: select comptncy_rt_id
7164: from BEN_COMPTNCY_RT_F

Line 7164: from BEN_COMPTNCY_RT_F

7160: -- START OF BEN_COMPTNCY_RT_F ----------------------
7161: ---------------------------------------------------------------
7162: cursor c_cty_from_parent(c_VRBL_RT_PRFL_ID number) is
7163: select comptncy_rt_id
7164: from BEN_COMPTNCY_RT_F
7165: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7166: --
7167: cursor c_cty(c_comptncy_rt_id number,c_mirror_src_entity_result_id number,
7168: c_table_alias varchar2 ) is

Line 7170: from BEN_COMPTNCY_RT_F cty

7166: --
7167: cursor c_cty(c_comptncy_rt_id number,c_mirror_src_entity_result_id number,
7168: c_table_alias varchar2 ) is
7169: select cty.*
7170: from BEN_COMPTNCY_RT_F cty
7171: where cty.comptncy_rt_id = c_comptncy_rt_id
7172: -- and cty.business_group_id = p_business_group_id
7173: and not exists (
7174: select /* */ null

Line 7181: -- and trt.where_clause = 'BEN_COMPTNCY_RT_F'

7177: where copy_entity_txn_id = p_copy_entity_txn_id
7178: -- and trt.table_route_id = cpe.table_route_id
7179: and ( -- c_mirror_src_entity_result_id is null or
7180: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7181: -- and trt.where_clause = 'BEN_COMPTNCY_RT_F'
7182: and cpe.table_alias = c_table_alias
7183: and information1 = c_comptncy_rt_id
7184: -- and information4 = cty.business_group_id
7185: and information2 = cty.effective_start_date

Line 7211: -- END OF BEN_COMPTNCY_RT_F ----------------------

7207: where competence_id = c_competence_id;
7208:
7209: l_competence_start_date per_competences.date_from%type;
7210: ---------------------------------------------------------------
7211: -- END OF BEN_COMPTNCY_RT_F ----------------------
7212: ---------------------------------------------------------------
7213: ---------------------------------------------------------------
7214: -- START OF BEN_JOB_RT_F ----------------------
7215: ---------------------------------------------------------------

Line 12613: -- START OF BEN_COMPTNCY_RT_F ----------------------

12609: ---------------------------------------------------------------
12610: -- END OF BEN_WK_LOC_RT_F ----------------------
12611: ---------------------------------------------------------------
12612: ---------------------------------------------------------------
12613: -- START OF BEN_COMPTNCY_RT_F ----------------------
12614: ---------------------------------------------------------------
12615: --
12616: hr_utility.set_location('START OF BEN_COMPTNCY_RT_F',100);
12617: for l_parent_rec in c_cty_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 12616: hr_utility.set_location('START OF BEN_COMPTNCY_RT_F',100);

12612: ---------------------------------------------------------------
12613: -- START OF BEN_COMPTNCY_RT_F ----------------------
12614: ---------------------------------------------------------------
12615: --
12616: hr_utility.set_location('START OF BEN_COMPTNCY_RT_F',100);
12617: for l_parent_rec in c_cty_from_parent(l_VRBL_RT_PRFL_ID) loop
12618: --
12619: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
12620:

Line 12776: hr_utility.set_location('END OF BEN_COMPTNCY_RT_F',100);

12772: --
12773: end loop;
12774: --
12775: end loop;
12776: hr_utility.set_location('END OF BEN_COMPTNCY_RT_F',100);
12777: ---------------------------------------------------------------
12778: -- END OF BEN_COMPTNCY_RT_F ----------------------
12779: ---------------------------------------------------------------
12780: ---------------------------------------------------------------

Line 12778: -- END OF BEN_COMPTNCY_RT_F ----------------------

12774: --
12775: end loop;
12776: hr_utility.set_location('END OF BEN_COMPTNCY_RT_F',100);
12777: ---------------------------------------------------------------
12778: -- END OF BEN_COMPTNCY_RT_F ----------------------
12779: ---------------------------------------------------------------
12780: ---------------------------------------------------------------
12781: -- START OF BEN_JOB_RT_F ----------------------
12782: ---------------------------------------------------------------