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_ACTY_VRBL_RT_F

Line 314: -- START OF BEN_ACTY_VRBL_RT_F ----------------------

310: ---------------------------------------------------------------
311: -- END OF BEN_ACTY_RT_PTD_LMT_F ----------------------
312: ---------------------------------------------------------------
313: ---------------------------------------------------------------
314: -- START OF BEN_ACTY_VRBL_RT_F ----------------------
315: ---------------------------------------------------------------
316: cursor c_avr_from_parent(c_ACTY_BASE_RT_ID number) is
317: select distinct acty_vrbl_rt_id
318: from BEN_ACTY_VRBL_RT_F

Line 318: from BEN_ACTY_VRBL_RT_F

314: -- START OF BEN_ACTY_VRBL_RT_F ----------------------
315: ---------------------------------------------------------------
316: cursor c_avr_from_parent(c_ACTY_BASE_RT_ID number) is
317: select distinct acty_vrbl_rt_id
318: from BEN_ACTY_VRBL_RT_F
319: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
320: --
321: cursor c_avr(c_acty_vrbl_rt_id number,c_mirror_src_entity_result_id number,
322: c_table_alias varchar ) is

Line 324: from BEN_ACTY_VRBL_RT_F avr

320: --
321: cursor c_avr(c_acty_vrbl_rt_id number,c_mirror_src_entity_result_id number,
322: c_table_alias varchar ) is
323: select avr.*
324: from BEN_ACTY_VRBL_RT_F avr
325: where avr.acty_vrbl_rt_id = c_acty_vrbl_rt_id
326: -- and avr.business_group_id = p_business_group_id
327: and not exists (
328: select /* */ null

Line 335: -- and trt.where_clause = 'BEN_ACTY_VRBL_RT_F'

331: where copy_entity_txn_id = p_copy_entity_txn_id
332: -- and trt.table_route_id = cpe.table_route_id
333: and ( -- c_mirror_src_entity_result_id is null or
334: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
335: -- and trt.where_clause = 'BEN_ACTY_VRBL_RT_F'
336: and cpe.table_alias = c_table_alias
337: and information1 = c_acty_vrbl_rt_id
338: -- and information4 = avr.business_group_id
339: and information2 = avr.effective_start_date

Line 349: -- and trt.where_clause = 'BEN_ACTY_VRBL_RT_F'

345: -- pqh_table_route trt
346: where copy_entity_txn_id = p_copy_entity_txn_id
347: -- and trt.table_route_id = cpe.table_route_id
348: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
349: -- and trt.where_clause = 'BEN_ACTY_VRBL_RT_F'
350: and cpe.table_alias = c_table_alias
351: and information1 = c_acty_vrbl_rt_id
352: -- and information4 = p_business_group_id
353: ;

Line 358: -- END OF BEN_ACTY_VRBL_RT_F ----------------------

354: --
355: l_acty_vrbl_rt_id number(15);
356: l_out_avr_result_id number(15);
357: ---------------------------------------------------------------
358: -- END OF BEN_ACTY_VRBL_RT_F ----------------------
359: ---------------------------------------------------------------
360: ---------------------------------------------------------------
361: -- START OF BEN_MTCHG_RT_F ----------------------
362: ---------------------------------------------------------------

Line 1790: -- START OF BEN_ACTY_VRBL_RT_F ----------------------

1786: ---------------------------------------------------------------
1787: -- END OF BEN_ACTY_RT_PTD_LMT_F ----------------------
1788: ---------------------------------------------------------------
1789: ---------------------------------------------------------------
1790: -- START OF BEN_ACTY_VRBL_RT_F ----------------------
1791: ---------------------------------------------------------------
1792: --
1793: hr_utility.set_location('c_avr_from_parent l_ACTY_BASE_RT_ID'||l_ACTY_BASE_RT_ID,100);
1794: for l_parent_rec in c_avr_from_parent(l_ACTY_BASE_RT_ID) loop

Line 1825: p_parent_entity_result_id => null, -- Hide BEN_ACTY_VRBL_RT_F for HGrid

1821: p_copy_entity_result_id => l_copy_entity_result_id,
1822: p_copy_entity_txn_id => p_copy_entity_txn_id,
1823: p_result_type_cd => l_result_type_cd,
1824: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
1825: p_parent_entity_result_id => null, -- Hide BEN_ACTY_VRBL_RT_F for HGrid
1826: p_number_of_copies => l_number_of_copies,
1827: p_table_route_id => l_table_route_id,
1828: P_TABLE_ALIAS => 'AVR',
1829: p_information1 => l_avr_rec.acty_vrbl_rt_id,

Line 1904: -- END OF BEN_ACTY_VRBL_RT_F ----------------------

1900: end loop;
1901: --
1902: end loop;
1903: ---------------------------------------------------------------
1904: -- END OF BEN_ACTY_VRBL_RT_F ----------------------
1905: ---------------------------------------------------------------
1906: ---------------------------------------------------------------
1907: -- START OF BEN_MTCHG_RT_F ----------------------
1908: ---------------------------------------------------------------