APPS.HR_ASSIGNMENT dependencies on PER_COBRA_COV_ENROLLMENTS

Line 2414: PER_COBRA_COV_ENROLLMENTS

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

Line 2424: PER_COBRA_COV_ENROLLMENTS

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

Line 2747: from PER_COBRA_COV_ENROLLMENTS

2743: into p_del_flag
2744: from sys.dual
2745: where exists (
2746: select null
2747: from PER_COBRA_COV_ENROLLMENTS
2748: where assignment_id = p_assignment_id
2749: and (p_mode = 'ZAP'
2750: or (p_mode = 'END'
2751: and coverage_start_date > p_end_date)));

Line 2776: from per_cobra_cov_enrollments e

2772: into p_del_flag
2773: from dual
2774: where exists
2775: (select null
2776: from per_cobra_cov_enrollments e
2777: , per_cobra_coverage_benefits_f b
2778: where e.assignment_id = P_ASSIGNMENT_ID
2779: and e.cobra_coverage_enrollment_id
2780: = b.cobra_coverage_enrollment_id

Line 4466: from per_cobra_cov_enrollments e

4462: into l_cobra_term_exists
4463: from sys.dual
4464: where exists
4465: (select null
4466: from per_cobra_cov_enrollments e
4467: where e.assignment_id = p_assignment_id
4468: and exists
4469: (select null
4470: from per_assignments_f a