DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_AC_EMP_SUM_ACTION_INFO_V

Line 2449: FROM PAY_AC_EMP_SUM_ACTION_INFO_V

2445: P_DOCUMENT_TYPE IN VARCHAR2) IS
2446:
2447: CURSOR get_net_pay(CP_ASSIGNMENT_ACTION_ID IN NUMBER) IS
2448: SELECT net_pay
2449: FROM PAY_AC_EMP_SUM_ACTION_INFO_V
2450: WHERE action_context_id = cp_assignment_action_id
2451: AND action_information_category = 'AC SUMMARY CURRENT';
2452:
2453: CURSOR get_net_pay_ytd(CP_ASSIGNMENT_ACTION_ID IN NUMBER) is

Line 2455: FROM PAY_AC_EMP_SUM_ACTION_INFO_V

2451: AND action_information_category = 'AC SUMMARY CURRENT';
2452:
2453: CURSOR get_net_pay_ytd(CP_ASSIGNMENT_ACTION_ID IN NUMBER) is
2454: SELECT net_pay
2455: FROM PAY_AC_EMP_SUM_ACTION_INFO_V
2456: WHERE action_context_id = cp_assignment_action_id
2457: AND ACTION_INFORMATION_CATEGORY = 'AC SUMMARY YTD';
2458:
2459: CURSOR get_check_depoad_details ( arch_assact_id in number ,