APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 1766: FROM pay_payrolls_f ppf,

1762: org.org_information2 employer_paye_ref_no,
1763: ppf.payroll_name payroll_name,
1764: ppf.period_type period_type,
1765: pact.pay_advice_message payroll_message
1766: FROM pay_payrolls_f ppf,
1767: pay_payroll_actions pact,
1768: hr_soft_coding_keyflex flex,
1769: hr_organization_information org
1770: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 1829: FROM pay_payrolls_f ppf,

1825: SELECT pact.payroll_action_id payroll_action_id,
1826: pact.effective_date effective_date,
1827: pact.date_earned date_earned,
1828: pact.pay_advice_message payroll_message
1829: FROM pay_payrolls_f ppf,
1830: pay_payroll_actions pact
1831: WHERE pact.payroll_id = ppf.payroll_id
1832: AND pact.effective_date BETWEEN
1833: ppf.effective_start_date AND ppf.effective_end_date

Line 2875: FROM pay_payrolls_f ppf,

2871: org.org_information2 employer_paye_ref_no,
2872: ppf.payroll_name payroll_name,
2873: ppf.period_type period_type,
2874: pact.pay_advice_message payroll_message
2875: FROM pay_payrolls_f ppf,
2876: pay_payroll_actions pact,
2877: hr_soft_coding_keyflex flex,
2878: hr_organization_information org
2879: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 2948: FROM pay_payrolls_f ppf,

2944: SELECT pact.payroll_action_id payroll_action_id,
2945: pact.effective_date effective_date,
2946: pact.date_earned date_earned,
2947: pact.pay_advice_message payroll_message
2948: FROM pay_payrolls_f ppf,
2949: pay_payroll_actions pact
2950: WHERE pact.payroll_id = ppf.payroll_id
2951: AND pact.effective_date BETWEEN
2952: ppf.effective_start_date AND ppf.effective_end_date