DBA Data[Home] [Help]

APPS.PAY_NL_ABP_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 359: FROM pay_payroll_actions ppa

355: AND to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') <= c_effective_date; --Bug 16301893
356: --=============================================================================
357: CURSOR csr_get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
358: SELECT ppa.payroll_action_id
359: FROM pay_payroll_actions ppa
360: ,pay_assignment_actions paa
361: WHERE paa.payroll_action_id = ppa.payroll_action_id
362: AND paa.assignment_action_id = c_assignment_action_id;
363: --=============================================================================

Line 723: FROM pay_payroll_actions

719: --=============================================================================
720: CURSOR c_bg_stdate(p_payroll_action_id IN NUMBER) IS
721: SELECT business_group_id bg_id
722: ,start_date start_date
723: FROM pay_payroll_actions
724: WHERE payroll_action_id = p_payroll_action_id;
725: --=============================================================================
726:
727: x NUMBER := 0;