DBA Data[Home] [Help]

APPS.PAY_GB_PAYE_CALC dependencies on PAY_PAYROLL_ACTIONS

Line 645: from pay_payroll_actions ppa,

641:
642: CURSOR cur_chk_pay_actions( p_payroll_action_id number, p_assignment_id number )
643: IS
644: select ppa.payroll_id old_payroll_id
645: from pay_payroll_actions ppa,
646: pay_assignment_actions paa
647: where ppa.payroll_action_id = paa.payroll_action_id
648: and paa.assignment_id = p_assignment_id
649: and ppa.payroll_action_id <> p_payroll_action_id

Line 817: pay_payroll_actions ppa

813: /*PAYE Details check for bug 6018309*/
814:
815: select regular_payment_date into l_pay_run_date
816: from per_time_periods ptp ,
817: pay_payroll_actions ppa
818: where ptp.time_period_id=ppa.time_period_id
819: and ppa.payroll_action_id=p_payroll_action_id;
820:
821:

Line 848: from pay_payroll_actions ppa

844: end if;
845: /* end of check for bug 6018309*/
846:
847: select effective_date into l_effective_date
848: from pay_payroll_actions ppa
849: where ppa.payroll_action_id=p_payroll_action_id;
850:
851:
852: hr_utility.set_location('effetive date:'||to_char(l_effective_date),12);