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.HXT_GEN_AAI dependencies on HXT_SHIFT_DIFF_RULES

Line 118: ,hxt_shift_diff_rules r

114: AND EXISTS
115: (select 1
116: from hxt_pay_element_types_f_ddf_v v
117: ,pay_element_types_f t
118: ,hxt_shift_diff_rules r
119: where r.sdp_id = sdp.id
120: and p_effective_start_date between r.effective_start_date
121: and r.effective_end_date
122: and t.element_type_id = r.element_type_id

Line 133: , hxt_shift_diff_rules hsdr

129: and v.hxt_earning_category = 'SDF')
130: AND NOT EXISTS
131: (select 1
132: from pay_element_types_f pet
133: , hxt_shift_diff_rules hsdr
134: where hsdr.sdp_id = sdp.id
135: and p_effective_start_date between hsdr.effective_start_date
136: and hsdr.effective_end_date
137: and pet.element_type_id = hsdr.element_type_id

Line 143: from hxt_shift_diff_rules dr

139: and pet.effective_end_date
140: and pet.business_group_id <> nvl(asg_bus_grp_id, -99))
141: AND NOT EXISTS
142: (select 1
143: from hxt_shift_diff_rules dr
144: where dr.sdp_id = sdp.id
145: and p_effective_start_date between dr.effective_start_date
146: and dr.effective_end_date
147: and dr.element_type_id not in

Line 151: ,hxt_shift_diff_rules sdr

147: and dr.element_type_id not in
148: (select sdr.element_type_id
149: from pay_element_links_f ell
150: ,per_assignments_f asm
151: ,hxt_shift_diff_rules sdr
152: where sdr.sdp_id = sdp.id
153: and p_effective_start_date between sdr.effective_start_date
154: and sdr.effective_end_date
155: and asm.assignment_id = p_assignment_id