APPS.PAY_GB_PAYE_CALC dependencies on HR_SOFT_CODING_KEYFLEX

Line 707: ,hr_soft_coding_keyflex scl

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

Line 714: ,hr_soft_coding_keyflex scl

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

Line 729: ,hr_soft_coding_keyflex scl

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
733: and l_effective_date between pap.effective_start_date and pap.effective_end_date;

Line 752: hr_soft_coding_keyflex hsck

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

Line 814: hr_soft_coding_keyflex hsck

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

Line 880: l_old_tax_reference hr_soft_coding_keyflex.segment1%type; --12662579 Begin

876: l_count_c number default 0;
877: l_aggregated_asg varchar2(10);
878: l_pay_run_date date;
879:
880: l_old_tax_reference hr_soft_coding_keyflex.segment1%type; --12662579 Begin
881: begin
882: l_return:=0;
883:
884:

Line 972: hr_soft_coding_keyflex scl

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
976: and ppa.action_type in ('Q', 'R', 'B', 'I' , 'V')