APPS.PER_ASG_BUS2 dependencies on PER_COBRA_COVERAGE_BENEFITS_F

Line 3081: -- - PER_COBRA_COVERAGE_BENEFITS_F

3077: -- - PAY_PAYROLL_ACTIONS
3078: -- - PAY_PERSONAL_PAYMENT_METHODS_F
3079: -- - PAY_ASSIGNMENT_ACTIONS
3080: -- - PER_COBRA_COV_ENROLLMENTS
3081: -- - PER_COBRA_COVERAGE_BENEFITS_F
3082: -- - PER_ASSIGNMENTS_EXTRA_INFO
3083: -- - HR_ASSIGNMENT_SET_AMENDMENTS
3084: -- - PER_SECONDARY_ASS_STATUSES
3085: --

Line 3199: from per_cobra_coverage_benefits_f b

3195: cursor csr_per_cobra_cov_bens is
3196: select null
3197: from sys.dual
3198: where exists(select null
3199: from per_cobra_coverage_benefits_f b
3200: , per_cobra_cov_enrollments e
3201: where e.assignment_id = p_assignment_id
3202: and e.cobra_coverage_enrollment_id =
3203: b.cobra_coverage_enrollment_id

Line 3333: -- assignment on per_cobra_coverage_benefits_f

3329: --
3330: hr_utility.set_location(l_proc, 8);
3331: --
3332: -- Check that no child records exist for the
3333: -- assignment on per_cobra_coverage_benefits_f
3334: -- when the assignment is deleted
3335: --
3336: open csr_per_cobra_cov_bens;
3337: fetch csr_per_cobra_cov_bens into l_exists;