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.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 4526: ,pay_all_payrolls_f ppf1

4522: ,pay_assignment_actions paa2
4523: ,pay_payroll_actions ppa2
4524: ,per_time_periods ptp1
4525: ,per_time_periods ptp2
4526: ,pay_all_payrolls_f ppf1
4527: ,pay_all_payrolls_f ppf2
4528: WHERE paa1.assignment_action_id = c_ass_act_id
4529: AND paa1.payroll_action_id = ppa1.payroll_action_id
4530: AND ppa1.payroll_id = ppf1.payroll_id

Line 4527: ,pay_all_payrolls_f ppf2

4523: ,pay_payroll_actions ppa2
4524: ,per_time_periods ptp1
4525: ,per_time_periods ptp2
4526: ,pay_all_payrolls_f ppf1
4527: ,pay_all_payrolls_f ppf2
4528: WHERE paa1.assignment_action_id = c_ass_act_id
4529: AND paa1.payroll_action_id = ppa1.payroll_action_id
4530: AND ppa1.payroll_id = ppf1.payroll_id
4531: AND ppa1.time_period_id = ptp1.time_period_id

Line 7186: ,pay_all_payrolls_f ppf

7182: ,c_paid_flag VARCHAR2) IS
7183: SELECT asl.assignment_id assignment_id
7184: ,paa.assignment_action_id assignment_action_id
7185: FROM per_all_assignments_f asl
7186: ,pay_all_payrolls_f ppf
7187: ,pay_payroll_actions ppa
7188: ,pay_assignment_actions paa
7189: ,per_time_periods ptp
7190: WHERE asl.person_id BETWEEN stperson AND endperson and

Line 7221: ,pay_all_payrolls_f ppf

7217: UNION
7218: SELECT asl.assignment_id assignment_id
7219: ,NULL assignment_action_id
7220: FROM per_all_assignments_f asl
7221: ,pay_all_payrolls_f ppf
7222: WHERE asl.person_id BETWEEN stperson AND endperson
7223: AND c_paid_flag = 'N'
7224: AND ppf.payroll_id = asl.payroll_id
7225: AND asl.assignment_type = 'E'

Line 7355: ,pay_all_payrolls_f ppf

7351: UNION
7352: SELECT asl.assignment_id assignment_id
7353: ,NULL assignment_action_id
7354: FROM per_all_assignments_f asl
7355: ,pay_all_payrolls_f ppf
7356: WHERE asl.person_id BETWEEN stperson AND endperson
7357: AND c_paid_flag = 'N'
7358: AND ppf.payroll_id = asl.payroll_id
7359: AND asl.assignment_type = 'E'

Line 7386: ,pay_all_payrolls_f ppf

7382: IS
7383: SELECT asl.assignment_id assignment_id
7384: ,paa.assignment_action_id assignment_action_id
7385: FROM per_all_assignments_f asl
7386: ,pay_all_payrolls_f ppf
7387: ,pay_payroll_actions ppa
7388: ,pay_assignment_actions paa
7389: ,per_time_periods ptp
7390: WHERE asl.person_id between stperson AND endperson and

Line 7460: ,pay_all_payrolls_f ppf

7456: UNION
7457: SELECT asl.assignment_id assignment_id
7458: ,NULL assignment_action_id
7459: FROM per_all_assignments_f asl
7460: ,pay_all_payrolls_f ppf
7461: WHERE asl.person_id BETWEEN stperson AND endperson
7462: AND c_paid_flag = 'N'
7463: AND ppf.payroll_id = asl.payroll_id
7464: AND asl.assignment_type = 'E'

Line 9988: ,pay_all_payrolls_f ppf

9984: ,c_payroll_type VARCHAR2) IS
9985: SELECT distinct asl.assignment_id assignment_id
9986: FROM per_all_assignments_f asl
9987: ,per_all_assignments_f asl2
9988: ,pay_all_payrolls_f ppf
9989: ,pay_payroll_actions ppa
9990: ,pay_assignment_actions paa
9991: ,per_time_periods ptp
9992: WHERE asl.person_id = asl2.person_id