APPS.PER_ASG_BUS2 dependencies on PER_COBRA_COVERAGE_BENEFITS_F

Line 3121: -- - PER_COBRA_COVERAGE_BENEFITS_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
3125: --

Line 3239: from per_cobra_coverage_benefits_f b

3235: cursor csr_per_cobra_cov_bens is
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

Line 3373: -- assignment on per_cobra_coverage_benefits_f

3369: --
3370: hr_utility.set_location(l_proc, 8);
3371: --
3372: -- Check that no child records exist for the
3373: -- assignment on per_cobra_coverage_benefits_f
3374: -- when the assignment is deleted
3375: --
3376: open csr_per_cobra_cov_bens;
3377: fetch csr_per_cobra_cov_bens into l_exists;