DBA Data[Home] [Help]

APPS.PA_IND_RATE_SCHEDULES_PKG dependencies on PA_IND_RATE_SCH_REVISIONS

Line 110: ,pa_ind_rate_sch_revisions prev

106: into x_dummy
107: from sys.dual
108: where exists (select 1
109: from pa_alloc_txn_details p
110: ,pa_ind_rate_sch_revisions prev
111: where p.ind_rate_sch_revision_id = prev.ind_rate_sch_revision_id
112: and prev.ind_rate_sch_id = x_ind_rate_sch_id );
113:
114: x_return_status := 1;

Line 180: -- check against PA_IND_RATE_SCH_REVISIONS

176: begin
177: x_return_status := 0;
178: x_stage := 0;
179:
180: -- check against PA_IND_RATE_SCH_REVISIONS
181: begin
182: select 1
183: into x_dummy
184: from sys.dual

Line 187: from pa_ind_rate_sch_revisions irsr

183: into x_dummy
184: from sys.dual
185: where not exists
186: (select 1
187: from pa_ind_rate_sch_revisions irsr
188: where irsr.ind_rate_sch_id = x_ind_rate_sch_id);
189:
190: x_return_status := 0;
191: