APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 1446: FROM pay_payrolls_f ppf,

1442: org.org_information8 tax_office_phone_no,
1443: ppf.payroll_name payroll_name,
1444: ppf.period_type period_type,
1445: pact.pay_advice_message payroll_message
1446: FROM pay_payrolls_f ppf,
1447: pay_payroll_actions pact,
1448: hr_soft_coding_keyflex flex,
1449: hr_organization_information org
1450: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 1477: FROM pay_payrolls_f ppf,

1473: SELECT pact.payroll_action_id payroll_action_id,
1474: pact.effective_date effective_date,
1475: pact.date_earned date_earned,
1476: pact.pay_advice_message payroll_message
1477: FROM pay_payrolls_f ppf,
1478: pay_payroll_actions pact
1479: WHERE pact.payroll_id = ppf.payroll_id
1480: AND pact.effective_date BETWEEN
1481: ppf.effective_start_date AND ppf.effective_end_date

Line 2356: FROM pay_payrolls_f ppf,

2352: org.org_information8 tax_office_phone_no,
2353: ppf.payroll_name payroll_name,
2354: ppf.period_type period_type,
2355: pact.pay_advice_message payroll_message
2356: FROM pay_payrolls_f ppf,
2357: pay_payroll_actions pact,
2358: hr_soft_coding_keyflex flex,
2359: hr_organization_information org
2360: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 2387: FROM pay_payrolls_f ppf,

2383: SELECT pact.payroll_action_id payroll_action_id,
2384: pact.effective_date effective_date,
2385: pact.date_earned date_earned,
2386: pact.pay_advice_message payroll_message
2387: FROM pay_payrolls_f ppf,
2388: pay_payroll_actions pact
2389: WHERE pact.payroll_id = ppf.payroll_id
2390: AND pact.effective_date BETWEEN
2391: ppf.effective_start_date AND ppf.effective_end_date