APPS.BEN_COVERED_DEPENDENTS_PKG dependencies on BEN_COVERED_DEPENDENTS_F

Line 12: FROM ben_covered_dependents_f

8: P_Effective_Start_Date DATE,
9: P_Effective_End_Date DATE ) IS
10: --
11: CURSOR C IS SELECT rowid
12: FROM ben_covered_dependents_f
13: WHERE covered_dependent_id = P_Covered_Dependent_Id
14: AND element_entry_id = P_Element_Entry_ID
15: ;
16: --

Line 28: INSERT INTO ben_covered_dependents_f (

24: FETCH C2 INTO P_Covered_Dependent_Id;
25: CLOSE C2;
26: end if;
27: --
28: INSERT INTO ben_covered_dependents_f (
29: covered_dependent_id,
30: contact_relationship_id,
31: element_entry_id,
32: effective_start_date,

Line 71: FROM ben_covered_dependents_f

67: --
68: --
69: CURSOR C IS
70: SELECT *
71: FROM ben_covered_dependents_f
72: WHERE rowid = P_Rowid
73: FOR UPDATE of Covered_Dependent_Id NOWAIT;
74: --
75: --

Line 138: UPDATE ben_covered_dependents_f

134: P_Effective_End_Date DATE
135: ) IS
136: BEGIN
137: --
138: UPDATE ben_covered_dependents_f
139: SET
140: covered_dependent_id = P_Covered_Dependent_Id,
141: contact_relationship_id = P_Contact_Relationship_Id,
142: element_entry_id = P_Element_Entry_Id,

Line 165: DELETE FROM ben_covered_dependents_f

161: PROCEDURE Delete_Row(P_Rowid VARCHAR2) IS
162: --
163: BEGIN
164: --
165: DELETE FROM ben_covered_dependents_f
166: WHERE rowid = P_Rowid;
167: --
168: if (SQL%NOTFOUND) then
169: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');