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.

[Home] [Help]

APPS.HR_EDW_WRK_CMPSTN_F_C dependencies on PER_PAY_PROPOSALS_V2

Line 529: , per_pay_proposals_v2 s

525: , per_pay_bases ppb
526: , per_time_period_types tpt
527: , pay_all_payrolls_f prl
528: , per_assignments_f a
529: , per_pay_proposals_v2 s
530: , hri_edw_cmpstn_snpsht_dts snp
531: where a.assignment_type = 'E'
532: and snp.snapshot_date between a.effective_start_date
533: and a.effective_end_date

Line 535: from per_pay_proposals_v2 ppp2

531: where a.assignment_type = 'E'
532: and snp.snapshot_date between a.effective_start_date
533: and a.effective_end_date
534: and s.change_date IN (select max(ppp2.change_date)
535: from per_pay_proposals_v2 ppp2
536: where ppp2.change_date < snp.snapshot_date
537: and ppp2.assignment_id = a.assignment_id)
538: and a.pay_basis_id = ppb.pay_basis_id
539: and ppb.input_value_id = piv.input_value_id