DBA Data[Home] [Help]

APPS.PAY_GB_PAYE_CALC dependencies on PAY_ASSIGNMENT_ACTIONS

Line 693: pay_assignment_actions paa

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

Line 970: pay_assignment_actions paa,

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
974: and paa.assignment_id = p_assignment_id