DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_PAYROLLS_F

Line 627: FROM pay_payrolls_f ppf

623: /* Modified the cursor for bug 5533140*/
624:
625: CURSOR get_value_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS
626: SELECT PRL_INFORMATION1
627: FROM pay_payrolls_f ppf
628: WHERE PAYROLL_ID = p_payroll_id
629: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
630:
631: CURSOR get_payroll_id (p_payroll_action_id NUMBER ) IS