APPS.HR_ASSIGNMENT dependencies on PER_COBRA_COV_ENROLLMENTS

Line 2377: PER_COBRA_COV_ENROLLMENTS

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:
2381: For 'END' (date effective delete)

Line 2387: PER_COBRA_COV_ENROLLMENTS

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
2391: PARAMETERS

Line 2710: from PER_COBRA_COV_ENROLLMENTS

2706: into p_del_flag
2707: from sys.dual
2708: where exists (
2709: select null
2710: from PER_COBRA_COV_ENROLLMENTS
2711: where assignment_id = p_assignment_id
2712: and (p_mode = 'ZAP'
2713: or (p_mode = 'END'
2714: and coverage_start_date > p_end_date)));

Line 2739: from per_cobra_cov_enrollments e

2735: into p_del_flag
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

Line 4426: from per_cobra_cov_enrollments e

4422: into l_cobra_term_exists
4423: from sys.dual
4424: where exists
4425: (select null
4426: from per_cobra_cov_enrollments e
4427: where e.assignment_id = p_assignment_id
4428: and exists
4429: (select null
4430: from per_assignments_f a