DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_AC_EMP_SUM_ACTION_INFO_V

Line 2509: FROM PAY_AC_EMP_SUM_ACTION_INFO_V

2505: P_DOCUMENT_TYPE IN VARCHAR2) IS
2506:
2507: CURSOR get_net_pay(CP_ASSIGNMENT_ACTION_ID IN NUMBER) IS
2508: SELECT net_pay
2509: FROM PAY_AC_EMP_SUM_ACTION_INFO_V
2510: WHERE action_context_id = cp_assignment_action_id
2511: AND action_information_category = 'AC SUMMARY CURRENT';
2512:
2513: CURSOR get_net_pay_ytd(CP_ASSIGNMENT_ACTION_ID IN NUMBER) is

Line 2515: FROM PAY_AC_EMP_SUM_ACTION_INFO_V

2511: AND action_information_category = 'AC SUMMARY CURRENT';
2512:
2513: CURSOR get_net_pay_ytd(CP_ASSIGNMENT_ACTION_ID IN NUMBER) is
2514: SELECT net_pay
2515: FROM PAY_AC_EMP_SUM_ACTION_INFO_V
2516: WHERE action_context_id = cp_assignment_action_id
2517: AND ACTION_INFORMATION_CATEGORY = 'AC SUMMARY YTD';
2518:
2519: CURSOR get_check_depoad_details ( arch_assact_id in number ,