APPS.HRWSECI dependencies on PER_COBRA_DEPENDENTS_F

Line 2745: from per_cobra_dependents_f cdp

2741: -- be undertaken by multiple employees.
2742: --
2743: cursor c1 is
2744: select null
2745: from per_cobra_dependents_f cdp
2746: where cdp.contact_relationship_id = p_contact_relationship_id
2747: and cdp.cobra_dependent_id <> nvl(p_cobra_dependent_id,-1)
2748: and (p_effective_start_date
2749: between cdp.effective_start_date

Line 2790: from per_cobra_dependents_f cdp

2786: l_dummy varchar2(1);
2787: --
2788: cursor c1 is
2789: select null
2790: from per_cobra_dependents_f cdp
2791: where cdp.cobra_dependent_id = nvl(p_cobra_dependent_id,-1)
2792: and cdp.contact_relationship_id = p_contact_relationship_id
2793: and cdp.effective_start_date = p_effective_start_date
2794: and cdp.effective_end_date = p_effective_end_date;

Line 2887: insert into per_cobra_dependents_f

2883: from dual;
2884: --
2885: p_object_version_number := 1;
2886: --
2887: insert into per_cobra_dependents_f
2888: (cobra_dependent_id,
2889: cobra_coverage_enrollment_id,
2890: contact_relationship_id,
2891: effective_start_date,

Line 3014: update per_cobra_dependents_f

3010: p_contact_relationship_id => p_contact_relationship_id,
3011: p_effective_start_date => p_effective_start_date,
3012: p_effective_end_date => p_effective_end_date);
3013: --
3014: update per_cobra_dependents_f
3015: set effective_start_date = p_effective_start_date,
3016: effective_end_date = p_effective_end_date,
3017: contact_relationship_id = p_contact_relationship_id,
3018: object_version_number = l_object_version_number,

Line 3054: delete from per_cobra_dependents_f

3050: p_object_version_number in number) is
3051: --
3052: begin
3053: --
3054: delete from per_cobra_dependents_f
3055: where cobra_dependent_id = p_cobra_dependent_id
3056: and effective_start_date = p_effective_start_date
3057: and effective_end_date = p_effective_end_date
3058: and object_version_number = p_object_version_number;

Line 3103: from per_cobra_dependents_f

3099: attribute17,
3100: attribute18,
3101: attribute19,
3102: attribute20
3103: from per_cobra_dependents_f
3104: where cobra_dependent_id = p_cobra_dependent_id
3105: and p_effective_start_date = effective_start_date
3106: and p_effective_end_date = effective_end_date
3107: for update nowait;

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

3136: -- The object is locked therefore we need to supply a meaningful
3137: -- error message.
3138: --
3139: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
3140: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3141: hr_utility.raise_error;
3142: --
3143: when l_object_invalid then
3144: --

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

3144: --
3145: -- The object doesn't exist or is invalid
3146: --
3147: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
3148: hr_utility.set_message_token('TABLE_NAME', 'per_cobra_dependents_f');
3149: hr_utility.raise_error;
3150: --
3151: end hr_cobra_do_cdp_lock;
3152: --

Line 3260: from per_cobra_dependents_f a

3256: -- was missing (bug 609701) and also the brackets (bug 669253).
3257: --
3258: cursor c1 is
3259: select null
3260: from per_cobra_dependents_f a
3261: where a.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
3262: and ( ( a.effective_start_date
3263: not between p_coverage_start_date
3264: and p_coverage_end_date )