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 3379: from per_cobra_dependents_f cdp

3375: -- be undertaken by multiple employees.
3376: --
3377: cursor c1 is
3378: select null
3379: from per_cobra_dependents_f cdp
3380: where cdp.contact_relationship_id = p_contact_relationship_id
3381: and cdp.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
3382: and cdp.cobra_dependent_id <> nvl(p_cobra_dependent_id,-1)
3383: and (p_effective_start_date

Line 3425: from per_cobra_dependents_f cdp

3421: l_dummy varchar2(1);
3422: --
3423: cursor c1 is
3424: select null
3425: from per_cobra_dependents_f cdp
3426: where cdp.cobra_dependent_id = nvl(p_cobra_dependent_id,-1)
3427: and cdp.contact_relationship_id = p_contact_relationship_id
3428: and cdp.effective_start_date = p_effective_start_date
3429: and cdp.effective_end_date = p_effective_end_date;

Line 3522: insert into per_cobra_dependents_f

3518: from dual;
3519: --
3520: p_object_version_number := 1;
3521: --
3522: insert into per_cobra_dependents_f
3523: (cobra_dependent_id,
3524: cobra_coverage_enrollment_id,
3525: contact_relationship_id,
3526: effective_start_date,

Line 3649: update per_cobra_dependents_f

3645: p_contact_relationship_id => p_contact_relationship_id,
3646: p_effective_start_date => p_effective_start_date,
3647: p_effective_end_date => p_effective_end_date);
3648: --
3649: update per_cobra_dependents_f
3650: set effective_start_date = p_effective_start_date,
3651: effective_end_date = p_effective_end_date,
3652: contact_relationship_id = p_contact_relationship_id,
3653: object_version_number = l_object_version_number,

Line 3696: delete from per_cobra_dependents_f

3692: hr_utility.trace('p_effective_start_date = ' || p_effective_start_date);
3693: hr_utility.trace('p_effective_end_date = ' || p_effective_end_date);
3694: hr_utility.trace('p_object_version_number= ' || p_object_version_number);
3695: --
3696: delete from per_cobra_dependents_f
3697: where cobra_dependent_id = p_cobra_dependent_id
3698: and effective_start_date = p_effective_start_date
3699: and effective_end_date = p_effective_end_date
3700: and object_version_number = p_object_version_number;

Line 3747: from per_cobra_dependents_f

3743: attribute17,
3744: attribute18,
3745: attribute19,
3746: attribute20
3747: from per_cobra_dependents_f
3748: where cobra_dependent_id = p_cobra_dependent_id
3749: and p_effective_start_date = effective_start_date
3750: and p_effective_end_date = effective_end_date
3751: for update nowait;

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

3780: -- The object is locked therefore we need to supply a meaningful
3781: -- error message.
3782: --
3783: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
3784: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3785: hr_utility.raise_error;
3786: --
3787: when l_object_invalid then
3788: --

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

3788: --
3789: -- The object doesn't exist or is invalid
3790: --
3791: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
3792: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3793: hr_utility.raise_error;
3794: --
3795: end hr_cobra_do_cdp_lock;
3796: --

Line 3907: from per_cobra_dependents_f a

3903: -- was missing (bug 609701) and also the brackets (bug 669253).
3904: --
3905: cursor c1 is
3906: select null
3907: from per_cobra_dependents_f a
3908: where a.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
3909: and ( ( a.effective_start_date
3910: not between p_coverage_start_date
3911: and p_coverage_end_date )