APPS.HRWSECI dependencies on PER_COBRA_COV_ENROLLMENTS

Line 79: from per_cobra_cov_enrollments a

75: -- by the use of this business rule.
76: --
77: cursor c1 is
78: select months_between(a.coverage_end_date,a.coverage_start_date)
79: from per_cobra_cov_enrollments a
80: where a.assignment_id = p_assignment_id
81: and a.cobra_coverage_enrollment_id <>
82: nvl(p_cobra_coverage_enrollment_id,-1);
83: --

Line 669: per_cobra_cov_enrollments_pkg.hr_cobra_chk_unique_enrollment (

665: --
666: --
667: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',1);
668: --
669: per_cobra_cov_enrollments_pkg.hr_cobra_chk_unique_enrollment (
670: p_cobra_coverage_enrollment_id,
671: p_assignment_id,
672: p_contact_relationship_id,
673: p_qualifying_event,

Line 705: per_cobra_cov_enrollments_pkg.insert_row(

701: --
702: --
703: hr_utility.set_location('hrwseci.hr_cobra_do_cce_insert',4);
704: --
705: per_cobra_cov_enrollments_pkg.insert_row(
706: p_rowid,
707: p_cobra_coverage_enrollment_id,
708: p_business_group_id,
709: p_assignment_id,

Line 1222: per_cobra_cov_enrollments_pkg.hr_cobra_chk_unique_enrollment (

1218: -- hr_utility.trace_on;
1219: --
1220: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 1);
1221: --
1222: per_cobra_cov_enrollments_pkg.hr_cobra_chk_unique_enrollment (
1223: p_cobra_coverage_enrollment_id,
1224: p_assignment_id,
1225: p_contact_relationship_id,
1226: p_qualifying_event,

Line 1233: per_cobra_cov_enrollments_pkg.update_row(

1229: hr_utility.set_location('hrwseci.hr_cobra_do_cce_update', 2);
1230: --
1231: -- do update
1232: --
1233: per_cobra_cov_enrollments_pkg.update_row(
1234: p_rowid,
1235: p_business_group_id,
1236: p_assignment_id,
1237: p_period_type,

Line 2624: from per_cobra_cov_enrollments cov

2620: -- be between the event coverage start and end dates.
2621: --
2622: cursor c1 is
2623: select null
2624: from per_cobra_cov_enrollments cov
2625: where cov.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
2626: and p_effective_start_date
2627: between cov.coverage_start_date
2628: and cov.coverage_end_date

Line 3213: from per_cobra_cov_enrollments a

3209: -- Ensure that two cobra events do not occur in the same timeframe
3210: --
3211: cursor c1 is
3212: select null
3213: from per_cobra_cov_enrollments a
3214: where a.cobra_coverage_enrollment_id <> nvl(p_cobra_coverage_enrollment_id,-1)
3215: and a.assignment_id = p_assignment_id
3216: and (p_coverage_start_date
3217: between a.coverage_start_date