APPS.PER_ASG_BUS2 dependencies on PER_COBRA_COV_ENROLLMENTS

Line 3120: -- - PER_COBRA_COV_ENROLLMENTS

3116: -- - PAY_COST_ALLOCATIONS_F
3117: -- - PAY_PAYROLL_ACTIONS
3118: -- - PAY_PERSONAL_PAYMENT_METHODS_F
3119: -- - PAY_ASSIGNMENT_ACTIONS
3120: -- - PER_COBRA_COV_ENROLLMENTS
3121: -- - PER_COBRA_COVERAGE_BENEFITS_F
3122: -- - PER_ASSIGNMENTS_EXTRA_INFO
3123: -- - HR_ASSIGNMENT_SET_AMENDMENTS
3124: -- - PER_SECONDARY_ASS_STATUSES

Line 3228: from per_cobra_cov_enrollments

3224: cursor csr_per_cobra_cov_enrol is
3225: select null
3226: from sys.dual
3227: where exists(select null
3228: from per_cobra_cov_enrollments
3229: where assignment_id = p_assignment_id
3230: and (p_datetrack_mode = 'ZAP'
3231: or ((p_datetrack_mode = 'DELETE'
3232: and coverage_start_date is null)

Line 3240: , per_cobra_cov_enrollments e

3236: select null
3237: from sys.dual
3238: where exists(select null
3239: from per_cobra_coverage_benefits_f b
3240: , per_cobra_cov_enrollments e
3241: where e.assignment_id = p_assignment_id
3242: and e.cobra_coverage_enrollment_id =
3243: b.cobra_coverage_enrollment_id
3244: and (p_datetrack_mode = 'ZAP'

Line 3358: -- assignment on per_cobra_cov_enrollments

3354: --
3355: hr_utility.set_location(l_proc, 7);
3356: --
3357: -- Check that no child records exist for the
3358: -- assignment on per_cobra_cov_enrollments
3359: -- when the assignment is deleted
3360: --
3361: open csr_per_cobra_cov_enrol;
3362: fetch csr_per_cobra_cov_enrol into l_exists;