DBA Data[Home] [Help]

APPS.PAY_CA_RULES dependencies on PAY_AC_EMP_SUM_ACTION_INFO_V

Line 395: FROM PAY_AC_EMP_SUM_ACTION_INFO_V

391: and ft.territory_code=pai.action_information13;
392:
393: CURSOR get_net_pay(CP_ASSIGNMENT_ACTION_ID IN NUMBER) IS
394: SELECT net_pay
395: FROM PAY_AC_EMP_SUM_ACTION_INFO_V
396: WHERE action_context_id = cp_assignment_action_id
397: AND action_information_category = 'AC SUMMARY CURRENT';
398:
399: CURSOR get_net_pay_ytd(CP_ASSIGNMENT_ACTION_ID IN NUMBER) is

Line 401: FROM PAY_AC_EMP_SUM_ACTION_INFO_V

397: AND action_information_category = 'AC SUMMARY CURRENT';
398:
399: CURSOR get_net_pay_ytd(CP_ASSIGNMENT_ACTION_ID IN NUMBER) is
400: SELECT net_pay
401: FROM PAY_AC_EMP_SUM_ACTION_INFO_V
402: WHERE action_context_id = cp_assignment_action_id
403: AND ACTION_INFORMATION_CATEGORY = 'AC SUMMARY YTD';
404:
405: CURSOR get_proposed_salary(CP_ASSIGNMENT_ACTION_ID IN NUMBER) is