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.HRI_BPL_SAL dependencies on PER_PAY_PROPOSALS_V2

Line 35: , per_pay_proposals_v2 s

31: , per_pay_bases ppb
32: --, per_time_period_types tpt -- bug 3547581
33: --, pay_all_payrolls_f prl -- bug 3547581
34: , per_assignments_f a
35: , per_pay_proposals_v2 s
36: where a.assignment_type = 'E'
37: and a.assignment_id = p_assignment_id
38: and p_effective_date between a.effective_start_date and a.effective_end_date
39: and s.change_date IN (select max(ppp2.change_date)

Line 40: from per_pay_proposals_v2 ppp2

36: where a.assignment_type = 'E'
37: and a.assignment_id = p_assignment_id
38: and p_effective_date between a.effective_start_date and a.effective_end_date
39: and s.change_date IN (select max(ppp2.change_date)
40: from per_pay_proposals_v2 ppp2
41: where ppp2.change_date <= p_effective_date
42: and ppp2.assignment_id = a.assignment_id)
43: and a.pay_basis_id = ppb.pay_basis_id
44: and ppb.input_value_id = piv.input_value_id