APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 1512: FROM pay_payrolls_f ppf,

1508: org.org_information8 tax_office_phone_no,
1509: ppf.payroll_name payroll_name,
1510: ppf.period_type period_type,
1511: pact.pay_advice_message payroll_message
1512: FROM pay_payrolls_f ppf,
1513: pay_payroll_actions pact,
1514: hr_soft_coding_keyflex flex,
1515: hr_organization_information org
1516: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 1543: FROM pay_payrolls_f ppf,

1539: SELECT pact.payroll_action_id payroll_action_id,
1540: pact.effective_date effective_date,
1541: pact.date_earned date_earned,
1542: pact.pay_advice_message payroll_message
1543: FROM pay_payrolls_f ppf,
1544: pay_payroll_actions pact
1545: WHERE pact.payroll_id = ppf.payroll_id
1546: AND pact.effective_date BETWEEN
1547: ppf.effective_start_date AND ppf.effective_end_date

Line 2452: FROM pay_payrolls_f ppf,

2448: org.org_information8 tax_office_phone_no,
2449: ppf.payroll_name payroll_name,
2450: ppf.period_type period_type,
2451: pact.pay_advice_message payroll_message
2452: FROM pay_payrolls_f ppf,
2453: pay_payroll_actions pact,
2454: hr_soft_coding_keyflex flex,
2455: hr_organization_information org
2456: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 2483: FROM pay_payrolls_f ppf,

2479: SELECT pact.payroll_action_id payroll_action_id,
2480: pact.effective_date effective_date,
2481: pact.date_earned date_earned,
2482: pact.pay_advice_message payroll_message
2483: FROM pay_payrolls_f ppf,
2484: pay_payroll_actions pact
2485: WHERE pact.payroll_id = ppf.payroll_id
2486: AND pact.effective_date BETWEEN
2487: ppf.effective_start_date AND ppf.effective_end_date