APPS.PAY_GB_PAYE_CALC dependencies on PAY_ALL_PAYROLLS_F

Line 706: from pay_all_payrolls_f pap

702:
703: CURSOR cur_check_payroll_tax_ref(p_old_payroll_id number, p_new_payroll_id number)
704: IS
705: select count(*) l_exist -- if this cursor fetches '1', that means new payroll is valid.
706: from pay_all_payrolls_f pap
707: ,hr_soft_coding_keyflex scl
708: where pap.payroll_id = p_new_payroll_id
709: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
710: and scl.segment1 in

Line 713: from pay_all_payrolls_f pap

709: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
710: and scl.segment1 in
711: (
712: select distinct scl.segment1
713: from pay_all_payrolls_f pap
714: ,hr_soft_coding_keyflex scl
715:
716: where
717: pap.payroll_id = p_old_payroll_id

Line 728: from pay_all_payrolls_f pap

724:
725: CURSOR cur_check_payroll_tax_ref(p_old_tax_reference varchar2, p_new_payroll_id number)
726: IS
727: select count(*) l_exist -- if this cursor fetches '1', that means new payroll is valid.
728: from pay_all_payrolls_f pap
729: ,hr_soft_coding_keyflex scl
730: where pap.payroll_id = p_new_payroll_id
731: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
732: and scl.segment1 = p_old_tax_reference

Line 751: from pay_all_payrolls_f papf,

747:
748: /* PAYE Details check for bug 6018309*/
749: CURSOR cur_get_tax_reference(c_payroll_id number) is
750: select hsck.segment1
751: from pay_all_payrolls_f papf,
752: hr_soft_coding_keyflex hsck
753: where
754: papf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
755: and papf.payroll_id=c_payroll_id;

Line 812: pay_all_payrolls_f papf,

808: pay_input_values_f inv,
809: pay_element_links_f lnk,
810: pay_element_types_f elt,
811:
812: pay_all_payrolls_f papf,
813: per_all_assignments_f paaf,
814: hr_soft_coding_keyflex hsck
815:
816: where ele.element_entry_id = eev.element_entry_id

Line 971: pay_all_payrolls_f pap,

967: --This will fetch the PAYE reference for the Assignment in the current Tax year
968: select distinct scl.segment1 into l_old_tax_reference
969: from pay_payroll_actions ppa,
970: pay_assignment_actions paa,
971: pay_all_payrolls_f pap,
972: hr_soft_coding_keyflex scl
973: where ppa.payroll_action_id = paa.payroll_action_id
974: and paa.assignment_id = p_assignment_id
975: and ppa.payroll_action_id <> p_payroll_action_id