APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 1187: from pay_payrolls_f ppf,

1183: p_end_date date
1184: ) is
1185: select pact.payroll_action_id payroll_action_id,
1186: pact.effective_date effective_date
1187: from pay_payrolls_f ppf,
1188: pay_payroll_actions pact -- Payroll Action of Prepayments
1189: where pact.payroll_id = ppf.payroll_id
1190: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
1191: and pact.payroll_id = nvl(p_payroll_id, pact.payroll_id)

Line 1928: from pay_payrolls_f ppf,

1924: pact.payroll_id,
1925: ppf.payroll_name payroll_name,
1926: ppf.period_type period_type,
1927: pact.pay_advice_message payroll_message
1928: from pay_payrolls_f ppf,
1929: pay_payroll_actions pact -- Payroll Action of Prepayments
1930: where pact.payroll_id = ppf.payroll_id
1931: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
1932: and pact.payroll_id = nvl(p_payroll_id, pact.payroll_id)

Line 1959: from pay_payrolls_f ppf,

1955: select pact.payroll_action_id payroll_action_id,
1956: pact.effective_date effective_date,
1957: pact.date_earned date_earned,
1958: pact.pay_advice_message payroll_message
1959: from pay_payrolls_f ppf,
1960: pay_payroll_actions pact -- Payroll Action of Run
1961: where pact.payroll_id = ppf.payroll_id
1962: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
1963: and pact.payroll_id = p_payroll_id

Line 2856: from pay_payrolls_f ppf,

2852: pact.payroll_id,
2853: ppf.payroll_name payroll_name,
2854: ppf.period_type period_type,
2855: pact.pay_advice_message payroll_message
2856: from pay_payrolls_f ppf,
2857: pay_payroll_actions pact -- Payroll Action of Prepayments
2858: where pact.payroll_id = ppf.payroll_id
2859: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
2860: and pact.payroll_id = nvl(p_payroll_id, pact.payroll_id)