APPS.PAY_GB_PAYE_CALC dependencies on PAY_ALL_PAYROLLS_F

Line 659: from pay_all_payrolls_f pap

655:
656: CURSOR cur_check_payroll_tax_ref(p_old_payroll_id number, p_new_payroll_id number)
657: IS
658: select count(*) l_exist -- if this cursor fetches '1', that means new payroll is valid.
659: from pay_all_payrolls_f pap
660: ,hr_soft_coding_keyflex scl
661: where pap.payroll_id = p_new_payroll_id
662: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
663: and scl.segment1 in

Line 666: from pay_all_payrolls_f pap

662: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
663: and scl.segment1 in
664: (
665: select distinct scl.segment1
666: from pay_all_payrolls_f pap
667: ,hr_soft_coding_keyflex scl
668:
669: where
670: pap.payroll_id = p_old_payroll_id

Line 690: from pay_all_payrolls_f papf,

686:
687: /* PAYE Details check for bug 6018309*/
688: CURSOR cur_get_tax_reference(c_payroll_id number) is
689: select hsck.segment1
690: from pay_all_payrolls_f papf,
691: hr_soft_coding_keyflex hsck
692: where
693: papf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
694: and papf.payroll_id=c_payroll_id;

Line 751: pay_all_payrolls_f papf,

747: pay_input_values_f inv,
748: pay_element_links_f lnk,
749: pay_element_types_f elt,
750:
751: pay_all_payrolls_f papf,
752: per_all_assignments_f paaf,
753: hr_soft_coding_keyflex hsck
754:
755: where ele.element_entry_id = eev.element_entry_id