APPS.PAY_GB_PAYE_CALC dependencies on HR_SOFT_CODING_KEYFLEX

Line 660: ,hr_soft_coding_keyflex scl

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
664: (

Line 667: ,hr_soft_coding_keyflex scl

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
671: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 691: hr_soft_coding_keyflex hsck

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;
695:

Line 753: hr_soft_coding_keyflex hsck

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
756: AND c_pay_run_date between ele.effective_start_date and ele.effective_end_date
757: AND eev.input_value_id + 0 = inv.input_value_id