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_COPY_TO_BEN_THREE dependencies on BEN_LOA_RSN_RT_F

Line 7832: -- and tr.where_clause = l_BEN_LOA_RSN_RT_F

7828: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7829: pqh_table_route tr
7830: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7831: and cpe.table_route_id = tr.table_route_id
7832: -- and tr.where_clause = l_BEN_LOA_RSN_RT_F
7833: and tr.table_alias = l_table_alias
7834: and cpe.number_of_copies = 1 -- ADDITION
7835: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7836: order by information1, information2; --added for bug: 5151945

Line 7870: from BEN_LOA_RSN_RT_F LAR

7866: c_business_group_id number,
7867: c_new_pk_id number) is
7868: select
7869: LAR.loa_rsn_rt_id new_value
7870: from BEN_LOA_RSN_RT_F LAR
7871: where
7872: LAR.ABSENCE_ATTENDANCE_TYPE_ID = l_ABSENCE_ATTENDANCE_TYPE_ID and
7873: nvl(LAR.ABS_ATTENDANCE_REASON_ID,-999) = nvl(l_ABS_ATTENDANCE_REASON_ID,-999) and
7874: LAR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and

Line 7883: from BEN_LOA_RSN_RT_F LAR1

7879: and effective_end_date ;
7880: --END TEMPIK
7881: /*TEMPIK
7882: and exists ( select null
7883: from BEN_LOA_RSN_RT_F LAR1
7884: where
7885: LAR1.ABSENCE_ATTENDANCE_TYPE_ID = l_ABSENCE_ATTENDANCE_TYPE_ID and
7886: nvl(LAR1.ABS_ATTENDANCE_REASON_ID,-999) = nvl(l_ABS_ATTENDANCE_REASON_ID,-999) and
7887: LAR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and

Line 7891: from BEN_LOA_RSN_RT_F LAR2

7887: LAR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
7888: LAR1.business_group_id = c_business_group_id
7889: and LAR1.effective_start_date <= c_effective_start_date )
7890: and exists ( select null
7891: from BEN_LOA_RSN_RT_F LAR2
7892: where
7893: LAR2.ABSENCE_ATTENDANCE_TYPE_ID = l_ABSENCE_ATTENDANCE_TYPE_ID and
7894: nvl(LAR2.ABS_ATTENDANCE_REASON_ID,-999) = nvl(l_ABS_ATTENDANCE_REASON_ID,-999) and
7895: LAR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and

Line 8052: (p_base_table_name => 'BEN_LOA_RSN_RT_F',

8048: if c_find_LAR_in_target%found then
8049: --
8050: --TEMPIK
8051: l_dt_rec_found := dt_api.check_min_max_dates
8052: (p_base_table_name => 'BEN_LOA_RSN_RT_F',
8053: p_base_key_column => 'LOA_RSN_RT_ID',
8054: p_base_key_value => l_new_value,
8055: p_from_date => l_min_esd,
8056: p_to_date => l_max_eed );

Line 8110: hr_utility.set_location(' BEN_LOA_RSN_RT_F CREATE_LOA_REASON_RATE ',20);

8106: end if;
8107:
8108: if l_first_rec and not l_update then
8109: -- Call Create routine.
8110: hr_utility.set_location(' BEN_LOA_RSN_RT_F CREATE_LOA_REASON_RATE ',20);
8111: BEN_LOA_REASON_RATE_API.CREATE_LOA_REASON_RATE(
8112: --
8113: P_VALIDATE => false
8114: ,P_EFFECTIVE_DATE => l_effective_date

Line 8204: hr_utility.set_location(' BEN_LOA_RSN_RT_F UPDATE_LOA_REASON_RATE ',30);

8200: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
8201: --
8202: IF l_update OR l_dml_operation <> 'UPDATE' THEN
8203: --UPD END
8204: hr_utility.set_location(' BEN_LOA_RSN_RT_F UPDATE_LOA_REASON_RATE ',30);
8205: BEN_LOA_REASON_RATE_API.UPDATE_LOA_REASON_RATE(
8206: --
8207: P_VALIDATE => false
8208: ,P_EFFECTIVE_DATE => l_effective_date