APPS.HR_ENTRY dependencies on BEN_COVERED_DEPENDENTS_F

Line 4356: from ben_covered_dependents_f DEP

4352: -- If p_end_date is NULL change the start date of the covered dependent
4353: cursor csr_covered_dependents is
4354: select rowid,
4355: dep.*
4356: from ben_covered_dependents_f DEP
4357: where dep.effective_end_date >= p_validation_start_date
4358: and dep.element_entry_id = p_element_entry_id;
4359: --
4360:

Line 4484: -- BEN_COVERED_DEPENDENTS_F (sic)

4480: -- PAY_ELEMENT_ENTRIES_F (If an abscence, or DT functions are being used).
4481: -- PAY_ELEMENT_ENTRY_VALUES_F (Entry Values are always deleted).
4482: -- PAY_RUN_RESULTS (If nonrecurring, and exist).
4483: -- PAY_RUN_RESULT_VALUES (If nonrecurring, and exist).
4484: -- BEN_COVERED_DEPENDENTS_F (sic)
4485: -- BEN_BENEFICIARIES_F
4486: --
4487:
4488: PROCEDURE del_3p_entry_values

Line 4567: from ben_covered_dependents_f DEP

4563: -- parent entry's end date prior to the extension of the end date.
4564: --
4565: select rowid,
4566: dep.*
4567: from ben_covered_dependents_f DEP
4568: where dep.element_entry_id = p_element_entry_id
4569: and dep.effective_end_date = p_validation_start_date -1;
4570: --
4571: begin

Line 6369: from ben_covered_dependents_f DEP

6365: --
6366: cursor csr_covered_dependents is
6367: select rowid,
6368: dep.*
6369: from ben_covered_dependents_f DEP
6370: where p_element_entry_EED between dep.effective_start_date and dep.effective_end_date
6371: and dep.element_entry_id = p_element_entry_id
6372: and not exists ( select null from ben_covered_dependents_f DEP2
6373: where dep2.element_entry_id = p_new_element_entry_id

Line 6372: and not exists ( select null from ben_covered_dependents_f DEP2

6368: dep.*
6369: from ben_covered_dependents_f DEP
6370: where p_element_entry_EED between dep.effective_start_date and dep.effective_end_date
6371: and dep.element_entry_id = p_element_entry_id
6372: and not exists ( select null from ben_covered_dependents_f DEP2
6373: where dep2.element_entry_id = p_new_element_entry_id
6374: and dep2.contact_relationship_id = dep.contact_relationship_id
6375: and dep2.effective_start_date between
6376: p_new_element_entry_ESD and p_new_element_entry_EED);

Line 6382: l_covered_dependent_id ben_covered_dependents_f.COVERED_DEPENDENT_ID%type;

6378:
6379: v_start_date date;
6380: v_end_date date;
6381: l_rowid rowid;
6382: l_covered_dependent_id ben_covered_dependents_f.COVERED_DEPENDENT_ID%type;
6383: l_action varchar2(10);
6384:
6385: begin
6386:

Line 6401: update ben_covered_dependents_f set effective_end_date = p_element_entry_EED

6397:
6398: -- bug 13031629 , fix : do not update element_entry_id if there are no future element_entries
6399:
6400: if p_new_element_entry_id is null then
6401: update ben_covered_dependents_f set effective_end_date = p_element_entry_EED
6402: where element_entry_id = p_element_entry_id;
6403: else
6404: update ben_covered_dependents_f set element_entry_id = p_new_element_entry_id
6405: where element_entry_id = p_element_entry_id;

Line 6404: update ben_covered_dependents_f set element_entry_id = p_new_element_entry_id

6400: if p_new_element_entry_id is null then
6401: update ben_covered_dependents_f set effective_end_date = p_element_entry_EED
6402: where element_entry_id = p_element_entry_id;
6403: else
6404: update ben_covered_dependents_f set element_entry_id = p_new_element_entry_id
6405: where element_entry_id = p_element_entry_id;
6406: end if;
6407: --
6408: else