APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 2053: FROM pay_payrolls_f ppf,

2049: org.org_information2 employer_paye_ref_no,
2050: ppf.payroll_name payroll_name,
2051: ppf.period_type period_type,
2052: pact.pay_advice_message payroll_message
2053: FROM pay_payrolls_f ppf,
2054: pay_payroll_actions pact,
2055: hr_soft_coding_keyflex flex,
2056: hr_organization_information org
2057: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 2116: FROM pay_payrolls_f ppf,

2112: SELECT pact.payroll_action_id payroll_action_id,
2113: pact.effective_date effective_date,
2114: pact.date_earned date_earned,
2115: pact.pay_advice_message payroll_message
2116: FROM pay_payrolls_f ppf,
2117: pay_payroll_actions pact
2118: WHERE pact.payroll_id = ppf.payroll_id
2119: AND pact.effective_date BETWEEN
2120: ppf.effective_start_date AND ppf.effective_end_date

Line 3190: FROM pay_payrolls_f ppf,

3186: org.org_information2 employer_paye_ref_no,
3187: ppf.payroll_name payroll_name,
3188: ppf.period_type period_type,
3189: pact.pay_advice_message payroll_message
3190: FROM pay_payrolls_f ppf,
3191: pay_payroll_actions pact,
3192: hr_soft_coding_keyflex flex,
3193: hr_organization_information org
3194: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 3263: FROM pay_payrolls_f ppf,

3259: SELECT pact.payroll_action_id payroll_action_id,
3260: pact.effective_date effective_date,
3261: pact.date_earned date_earned,
3262: pact.pay_advice_message payroll_message
3263: FROM pay_payrolls_f ppf,
3264: pay_payroll_actions pact
3265: WHERE pact.payroll_id = ppf.payroll_id
3266: AND pact.effective_date BETWEEN
3267: ppf.effective_start_date AND ppf.effective_end_date