APPS.HR_ASSIGNMENT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 2376: PAY_ASSIGNMENT_ACTIONS

2372: PAY_COST_ALLOCATIONS_F
2373: PER_ASSIGNMENT_EXTRA_INFO
2374: PAY_PERSONAL_PAYMENT_METHODS_F
2375: HR_ASSIGNMENT_SET_AMENDMENTS
2376: PAY_ASSIGNMENT_ACTIONS
2377: PER_COBRA_COV_ENROLLMENTS
2378: PER_COBRA_COVERAGE_BENEFITS_F
2379: OTA_DELEGATE_BOOKINGS (per_ota_predel_validation.ota_predel_asg_validation)
2380:

Line 2386: PAY_ASSIGNMENT_ACTIONS

2382: PER_EVENTS
2383: PER_LETTER_REQUEST_LINES
2384: PAY_COST_ALLOCATIONS_F
2385: PAY_PERSONAL_PAYMENT_METHODS_F
2386: PAY_ASSIGNMENT_ACTIONS
2387: PER_COBRA_COV_ENROLLMENTS
2388: PER_COBRA_COVERAGE_BENEFITS_F
2389:
2390: Determines whether the delete operation is permissible

Line 2614: , pay_assignment_actions aa

2610: from sys.dual
2611: where exists
2612: (select null
2613: from pay_payroll_actions ps
2614: , pay_assignment_actions aa
2615: where aa.assignment_id = P_ASSIGNMENT_ID
2616: and ps.payroll_action_id = aa.payroll_action_id
2617: and ps.action_type not in ('X','BEE') --Added for bug2956160
2618: and (P_MODE = 'ZAP'

Line 2633: , pay_assignment_actions aa

2629: from dual
2630: where exists
2631: (select null
2632: from pay_payroll_actions ps
2633: , pay_assignment_actions aa
2634: where aa.assignment_id = P_ASSIGNMENT_ID
2635: and ps.action_type not in ('X','BEE') --Added for bug2956160
2636: and ps.payroll_action_id = aa.payroll_action_id);
2637: EXCEPTION

Line 2649: , pay_assignment_actions aa

2645: from sys.dual
2646: where exists
2647: (select null
2648: from pay_payroll_actions ps
2649: , pay_assignment_actions aa
2650: where aa.assignment_id = P_ASSIGNMENT_ID
2651: and ps.payroll_action_id = aa.payroll_action_id
2652: and ps.action_type not in ('X','BEE') --Added for bug2956160
2653: and ps.effective_date > P_END_DATE);