APPS.PAY_GB_RTI_FPS dependencies on PAY_ALL_PAYROLLS_F

Line 1568: pay_all_payrolls_f pay,

1564: IS
1565: SELECT min(paaf.effective_start_date) min_active_start_date
1566: FROM per_all_assignments_f paaf,
1567: per_assignment_status_types past,
1568: pay_all_payrolls_f pay,
1569: hr_soft_coding_keyflex sck
1570: WHERE paaf.assignment_id = p_asg_id
1571: AND paaf.assignment_status_type_id = past.assignment_status_type_id
1572: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 2376: pay_all_payrolls_f pay,

2372: IS
2373: SELECT min(paaf.effective_start_date) min_active_start_date
2374: FROM per_all_assignments_f paaf,
2375: per_assignment_status_types past,
2376: pay_all_payrolls_f pay,
2377: hr_soft_coding_keyflex sck
2378: WHERE paaf.assignment_id = p_asg_id
2379: AND paaf.assignment_status_type_id = past.assignment_status_type_id
2380: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 3190: pay_all_payrolls_f pay,

3186: IS
3187: SELECT min(paaf.effective_start_date) min_active_start_date
3188: FROM per_all_assignments_f paaf,
3189: per_assignment_status_types past,
3190: pay_all_payrolls_f pay,
3191: hr_soft_coding_keyflex sck
3192: WHERE paaf.assignment_id = p_asg_id
3193: AND paaf.assignment_status_type_id = past.assignment_status_type_id
3194: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 3784: pay_all_payrolls_f papf ,

3780: l_eff_date date;
3781: cursor csr_get_start_date is
3782: select paaf.effective_start_date from
3783: per_all_assignments_f paaf,
3784: pay_all_payrolls_f papf ,
3785: hr_soft_coding_keyflex flex,
3786: per_assignment_status_types past
3787: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
3788: and papf.payroll_id = paaf.payroll_id

Line 6043: from pay_all_payrolls_f papf,

6039: where ppa.effective_date >= sysdate - 30
6040: and ppa.action_type in ('P','U')
6041: and ppa.action_status ='C'
6042: and ppa.payroll_id in (select distinct payroll_id
6043: from pay_all_payrolls_f papf,
6044: hr_soft_coding_keyflex flex
6045: where upper(flex.segment1) = c_tax_ref
6046: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID)
6047: minus

Line 6627: pay_all_payrolls_f papf ,

6623: pay_assignment_actions act, --Payroll Run
6624: pay_assignment_actions act1, --Prepayments
6625: pay_action_interlocks pai, --Prepayments
6626: per_all_assignments_f as1,
6627: pay_all_payrolls_f papf ,
6628: hr_soft_coding_keyflex flex
6629: WHERE as1.person_id = p_person_id --58105
6630: AND appa.action_type IN ('R','Q','V','B') -- Payroll Run or Quickpay Run
6631: AND act.payroll_action_id = appa.payroll_action_id