DBA Data[Home] [Help]

APPS.HR_ENTRY dependencies on BEN_COVERED_DEPENDENTS_F

Line 3980: from ben_covered_dependents_f DEP

3976: -- If p_end_date is NULL change the start date of the covered dependent
3977: cursor csr_covered_dependents is
3978: select rowid,
3979: dep.*
3980: from ben_covered_dependents_f DEP
3981: where dep.effective_end_date >= p_validation_start_date
3982: and dep.element_entry_id = p_element_entry_id;
3983: --
3984:

Line 4108: -- BEN_COVERED_DEPENDENTS_F (sic)

4104: -- PAY_ELEMENT_ENTRIES_F (If an abscence, or DT functions are being used).
4105: -- PAY_ELEMENT_ENTRY_VALUES_F (Entry Values are always deleted).
4106: -- PAY_RUN_RESULTS (If nonrecurring, and exist).
4107: -- PAY_RUN_RESULT_VALUES (If nonrecurring, and exist).
4108: -- BEN_COVERED_DEPENDENTS_F (sic)
4109: -- BEN_BENEFICIARIES_F
4110: --
4111:
4112: PROCEDURE del_3p_entry_values

Line 4191: from ben_covered_dependents_f DEP

4187: -- parent entry's end date prior to the extension of the end date.
4188: --
4189: select rowid,
4190: dep.*
4191: from ben_covered_dependents_f DEP
4192: where dep.element_entry_id = p_element_entry_id
4193: and dep.effective_end_date = p_validation_start_date -1;
4194: --
4195: begin