APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 4356: pay_all_payrolls_f papf ,

4352: l_eff_date date;
4353: cursor csr_get_start_date is
4354: select paaf.effective_start_date from
4355: per_all_assignments_f paaf,
4356: pay_all_payrolls_f papf ,
4357: hr_soft_coding_keyflex flex,
4358: per_assignment_status_types past
4359: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
4360: and papf.payroll_id = paaf.payroll_id

Line 6676: from pay_all_payrolls_f papf,

6672: where ppa.effective_date >= sysdate - 30
6673: and ppa.action_type in ('P','U')
6674: and ppa.action_status ='C'
6675: and ppa.payroll_id in (select distinct payroll_id
6676: from pay_all_payrolls_f papf,
6677: hr_soft_coding_keyflex flex
6678: where upper(flex.segment1) = c_tax_ref
6679: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID)
6680: minus

Line 7296: pay_all_payrolls_f papf ,

7292: pay_assignment_actions act, --Payroll Run
7293: pay_assignment_actions act1, --Prepayments
7294: pay_action_interlocks pai, --Prepayments
7295: per_all_assignments_f as1,
7296: pay_all_payrolls_f papf ,
7297: hr_soft_coding_keyflex flex
7298: WHERE as1.person_id = p_person_id --58105
7299: AND appa.action_type IN ('R','Q','V','B') -- Payroll Run or Quickpay Run
7300: AND act.payroll_action_id = appa.payroll_action_id