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.HR_NZBAL dependencies on PAY_PAYROLLS_F

Line 124: , pay_payrolls_f ppf

120: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
121: FROM pay_assignment_actions paa
122: , pay_payroll_actions ppa
123: , per_assignments_f paf
124: , pay_payrolls_f ppf
125: , per_time_periods ptp
126: WHERE paf.assignment_id = c_assignment_id
127: AND paf.assignment_id = paa.assignment_id
128: AND ppf.payroll_id = ppa.payroll_id

Line 636: , pay_payrolls_f ppf

632: SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
633: FROM pay_assignment_actions paa
634: , pay_payroll_actions ppa
635: , per_assignments_f paf
636: , pay_payrolls_f ppf
637: , per_time_periods ptp
638: WHERE paf.assignment_id = c_assignment_id
639: AND paf.assignment_id = paa.assignment_id
640: AND ppf.payroll_id = ppa.payroll_id

Line 666: , pay_payrolls_f ppf

662: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
663: FROM pay_assignment_actions paa
664: , pay_payroll_actions ppa
665: , per_assignments_f paf
666: , pay_payrolls_f ppf
667: , per_time_periods ptp
668: WHERE paf.assignment_id = c_assignment_id
669: AND paf.assignment_id = paa.assignment_id
670: AND ppf.payroll_id = ppa.payroll_id