APPS.HR_ASSIGNMENT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 2413: PAY_ASSIGNMENT_ACTIONS

2409: PAY_COST_ALLOCATIONS_F
2410: PER_ASSIGNMENT_EXTRA_INFO
2411: PAY_PERSONAL_PAYMENT_METHODS_F
2412: HR_ASSIGNMENT_SET_AMENDMENTS
2413: PAY_ASSIGNMENT_ACTIONS
2414: PER_COBRA_COV_ENROLLMENTS
2415: PER_COBRA_COVERAGE_BENEFITS_F
2416: OTA_DELEGATE_BOOKINGS (per_ota_predel_validation.ota_predel_asg_validation)
2417:

Line 2423: PAY_ASSIGNMENT_ACTIONS

2419: PER_EVENTS
2420: PER_LETTER_REQUEST_LINES
2421: PAY_COST_ALLOCATIONS_F
2422: PAY_PERSONAL_PAYMENT_METHODS_F
2423: PAY_ASSIGNMENT_ACTIONS
2424: PER_COBRA_COV_ENROLLMENTS
2425: PER_COBRA_COVERAGE_BENEFITS_F
2426:
2427: Determines whether the delete operation is permissible

Line 2651: , pay_assignment_actions aa

2647: from sys.dual
2648: where exists
2649: (select null
2650: from pay_payroll_actions ps
2651: , pay_assignment_actions aa
2652: where aa.assignment_id = P_ASSIGNMENT_ID
2653: and ps.payroll_action_id = aa.payroll_action_id
2654: and ps.action_type not in ('X','BEE') --Added for bug2956160
2655: and (P_MODE = 'ZAP'

Line 2670: , pay_assignment_actions aa

2666: from dual
2667: where exists
2668: (select null
2669: from pay_payroll_actions ps
2670: , pay_assignment_actions aa
2671: where aa.assignment_id = P_ASSIGNMENT_ID
2672: and ps.action_type not in ('X','BEE') --Added for bug2956160
2673: and ps.payroll_action_id = aa.payroll_action_id);
2674: EXCEPTION

Line 2686: , pay_assignment_actions aa

2682: from sys.dual
2683: where exists
2684: (select null
2685: from pay_payroll_actions ps
2686: , pay_assignment_actions aa
2687: where aa.assignment_id = P_ASSIGNMENT_ID
2688: and ps.payroll_action_id = aa.payroll_action_id
2689: and ps.action_type not in ('X','BEE') --Added for bug2956160
2690: and ps.effective_date > P_END_DATE);