APPS.PER_COBRA_ECI dependencies on PER_COBRA_DEPENDENTS_F

Line 2259: from per_cobra_dependents_f

2255: ld_eff_start_date date;
2256:
2257: cursor c_get_cobra_dependents IS
2258: select cobra_dependent_id,effective_end_date,object_version_number,effective_start_date
2259: from per_cobra_dependents_f
2260: where cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
2261: and p_session_date between effective_start_date and effective_end_date;
2262:
2263:

Line 2276: update per_cobra_dependents_f

2272: exit when c_get_cobra_dependents%NOTFOUND;
2273:
2274: if c_get_cobra_dependents%FOUND then
2275:
2276: update per_cobra_dependents_f
2277: set effective_end_date = ld_session_date,
2278: object_version_number = ln_ovn + 1
2279: where cobra_dependent_id = ln_cdp_id
2280: and effective_start_date = ld_eff_start_date

Line 3374: from per_cobra_dependents_f cdp

3370: -- be undertaken by multiple employees.
3371: --
3372: cursor c1 is
3373: select null
3374: from per_cobra_dependents_f cdp
3375: where cdp.contact_relationship_id = p_contact_relationship_id
3376: and cdp.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
3377: and cdp.cobra_dependent_id <> nvl(p_cobra_dependent_id,-1)
3378: and (p_effective_start_date

Line 3420: from per_cobra_dependents_f cdp

3416: l_dummy varchar2(1);
3417: --
3418: cursor c1 is
3419: select null
3420: from per_cobra_dependents_f cdp
3421: where cdp.cobra_dependent_id = nvl(p_cobra_dependent_id,-1)
3422: and cdp.contact_relationship_id = p_contact_relationship_id
3423: and cdp.effective_start_date = p_effective_start_date
3424: and cdp.effective_end_date = p_effective_end_date;

Line 3517: insert into per_cobra_dependents_f

3513: from dual;
3514: --
3515: p_object_version_number := 1;
3516: --
3517: insert into per_cobra_dependents_f
3518: (cobra_dependent_id,
3519: cobra_coverage_enrollment_id,
3520: contact_relationship_id,
3521: effective_start_date,

Line 3644: update per_cobra_dependents_f

3640: p_contact_relationship_id => p_contact_relationship_id,
3641: p_effective_start_date => p_effective_start_date,
3642: p_effective_end_date => p_effective_end_date);
3643: --
3644: update per_cobra_dependents_f
3645: set effective_start_date = p_effective_start_date,
3646: effective_end_date = p_effective_end_date,
3647: contact_relationship_id = p_contact_relationship_id,
3648: object_version_number = l_object_version_number,

Line 3691: delete from per_cobra_dependents_f

3687: hr_utility.trace('p_effective_start_date = ' || p_effective_start_date);
3688: hr_utility.trace('p_effective_end_date = ' || p_effective_end_date);
3689: hr_utility.trace('p_object_version_number= ' || p_object_version_number);
3690: --
3691: delete from per_cobra_dependents_f
3692: where cobra_dependent_id = p_cobra_dependent_id
3693: and effective_start_date = p_effective_start_date
3694: and effective_end_date = p_effective_end_date
3695: and object_version_number = p_object_version_number;

Line 3742: from per_cobra_dependents_f

3738: attribute17,
3739: attribute18,
3740: attribute19,
3741: attribute20
3742: from per_cobra_dependents_f
3743: where cobra_dependent_id = p_cobra_dependent_id
3744: and p_effective_start_date = effective_start_date
3745: and p_effective_end_date = effective_end_date
3746: for update nowait;

Line 3779: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');

3775: -- The object is locked therefore we need to supply a meaningful
3776: -- error message.
3777: --
3778: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
3779: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3780: hr_utility.raise_error;
3781: --
3782: when l_object_invalid then
3783: --

Line 3787: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');

3783: --
3784: -- The object doesn't exist or is invalid
3785: --
3786: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
3787: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3788: hr_utility.raise_error;
3789: --
3790: end hr_cobra_do_cdp_lock;
3791: --

Line 3902: from per_cobra_dependents_f a

3898: -- was missing (bug 609701) and also the brackets (bug 669253).
3899: --
3900: cursor c1 is
3901: select null
3902: from per_cobra_dependents_f a
3903: where a.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
3904: and ( ( a.effective_start_date
3905: not between p_coverage_start_date
3906: and p_coverage_end_date )