APPS.PER_ASG_BUS2 dependencies on PER_COBRA_COV_ENROLLMENTS

Line 3080: -- - PER_COBRA_COV_ENROLLMENTS

3076: -- - PAY_COST_ALLOCATIONS_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

Line 3188: from per_cobra_cov_enrollments

3184: cursor csr_per_cobra_cov_enrol is
3185: select null
3186: from sys.dual
3187: where exists(select null
3188: from per_cobra_cov_enrollments
3189: where assignment_id = p_assignment_id
3190: and (p_datetrack_mode = 'ZAP'
3191: or ((p_datetrack_mode = 'DELETE'
3192: and coverage_start_date is null)

Line 3200: , per_cobra_cov_enrollments e

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
3204: and (p_datetrack_mode = 'ZAP'

Line 3318: -- assignment on per_cobra_cov_enrollments

3314: --
3315: hr_utility.set_location(l_proc, 7);
3316: --
3317: -- Check that no child records exist for the
3318: -- assignment on per_cobra_cov_enrollments
3319: -- when the assignment is deleted
3320: --
3321: open csr_per_cobra_cov_enrol;
3322: fetch csr_per_cobra_cov_enrol into l_exists;