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_EARNING_RULES

Line 46: , hxt_earning_rules r

42: AND EXISTS
43: (select 1
44: from hxt_pay_element_types_f_ddf_v v
45: , pay_element_types_f t
46: , hxt_earning_rules r
47: where r.egp_id = erp.id
48: and p_effective_start_date between r.effective_start_date
49: and r.effective_end_date
50: and t.element_type_id = r.element_type_id

Line 61: from hxt_earning_rules er

57: and v.effective_end_date
58: and v.hxt_earning_category in ('ABS', 'OVT', 'REG'))
59: AND NOT EXISTS
60: (select 1
61: from hxt_earning_rules er
62: where er.egp_id = erp.id
63: and p_effective_start_date between er.effective_start_date
64: and er.effective_end_date
65: and er.element_type_id NOT IN

Line 69: , hxt_earning_rules ern

65: and er.element_type_id NOT IN
66: (select ern.element_type_id
67: from pay_element_links_f ell
68: , per_assignments_f asm
69: , hxt_earning_rules ern
70: where ern.egp_id = erp.id
71: and p_effective_start_date between ern.effective_start_date
72: and ern.effective_end_date
73: and asm.assignment_id = p_assignment_id