APPS.IEX_DUNNING_PLANS_PKG dependencies on IEX_DUNNING_PLANS_B

Line 25: select ROWID from iex_dunning_plans_b

21: x_PROGRAM_ID in NUMBER,
22: x_PROGRAM_UPDATE_DATE in DATE
23: ) is
24: cursor l_insert is
25: select ROWID from iex_dunning_plans_b
26: where dunning_plan_id = x_dunning_plan_id ;
27: l_rowid varchar2(2000);
28: begin
29:

Line 30: insert into iex_dunning_plans_b (

26: where dunning_plan_id = x_dunning_plan_id ;
27: l_rowid varchar2(2000);
28: begin
29:
30: insert into iex_dunning_plans_b (
31: DUNNING_PLAN_ID,
32: START_DATE,
33: END_DATE,
34: ENABLED_FLAG,

Line 135: from iex_dunning_plans_b

131: ENABLED_FLAG,
132: AGING_BUCKET_ID,
133: SCORE_ID,
134: DUNNING_LEVEL
135: from iex_dunning_plans_b
136: where dunning_plan_id = x_dunning_plan_id
137: for update of dunning_plan_id nowait;
138:
139: recinfo c%rowtype;

Line 216: update iex_dunning_plans_b set

212: x_PROGRAM_ID in NUMBER,
213: x_PROGRAM_UPDATE_DATE in DATE
214: ) is
215: begin
216: update iex_dunning_plans_b set
217: START_DATE = x_start_date,
218: END_DATE = x_end_date,
219: ENABLED_FLAG = x_enabled_flag,
220: AGING_BUCKET_ID = x_aging_bucket_id,

Line 259: delete from iex_dunning_plans_b

255: if (sql%notfound) then
256: raise no_data_found;
257: end if;
258:
259: delete from iex_dunning_plans_b
260: where dunning_plan_id = x_dunning_plan_id;
261:
262: if (sql%notfound) then
263: raise no_data_found;

Line 280: from iex_dunning_plans_b B

276: begin
277: delete from iex_dunning_plans_tl T
278: where not exists
279: (select NULL
280: from iex_dunning_plans_b B
281: where B.dunning_plan_id = T.dunning_plan_id
282: );
283:
284: update iex_dunning_plans_tl T set (