[Home] [Help]
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:
2381: For 'END' (date effective delete)
2382: PER_EVENTS
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
2391: PARAMETERS
2392: p_assignment_id - The current assignment
2736: from dual
2737: where exists
2738: (select null
2739: from per_cobra_cov_enrollments e
2740: , per_cobra_coverage_benefits_f b
2741: where e.assignment_id = P_ASSIGNMENT_ID
2742: and e.cobra_coverage_enrollment_id
2743: = b.cobra_coverage_enrollment_id
2744: and (p_mode = 'ZAP'