APPS.PAY_GB_PAYE_CALC dependencies on PAY_PAYROLL_ACTIONS

Line 651: FROM PAY_PAYROLL_ACTIONS

647: hr_utility.set_location(' l_request_id '||l_request_id , 20);
648: BEGIN
649: SELECT 1
650: INTO l_retro_status
651: FROM PAY_PAYROLL_ACTIONS
652: WHERE request_id = l_request_id
653: AND ACTION_TYPE IN ('L','G','O');
654: hr_utility.set_location('**** This is retro ' , 30);
655: hr_utility.set_location(' Value of l_retro_status is : '||l_retro_status , 40);

Line 692: from pay_payroll_actions ppa,

688: /*12662579 Begin
689: CURSOR cur_chk_pay_actions( p_payroll_action_id number, p_assignment_id number )
690: IS
691: select ppa.payroll_id old_payroll_id
692: from pay_payroll_actions ppa,
693: pay_assignment_actions paa
694: where ppa.payroll_action_id = paa.payroll_action_id
695: and paa.assignment_id = p_assignment_id
696: and ppa.payroll_action_id <> p_payroll_action_id

Line 893: pay_payroll_actions ppa

889: /*PAYE Details check for bug 6018309*/
890:
891: select regular_payment_date into l_pay_run_date
892: from per_time_periods ptp ,
893: pay_payroll_actions ppa
894: where ptp.time_period_id=ppa.time_period_id
895: and ppa.payroll_action_id=p_payroll_action_id;
896:
897:

Line 935: from pay_payroll_actions ppa

931: end if;
932: /* end of check for bug 6018309*/
933:
934: select effective_date into l_effective_date
935: from pay_payroll_actions ppa
936: where ppa.payroll_action_id=p_payroll_action_id;
937:
938:
939: hr_utility.set_location('effetive date:'||to_char(l_effective_date),12);

Line 969: from pay_payroll_actions ppa,

965: begin
966: hr_utility.set_location('Before fetching tax references for this Assignment ',11);
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