APPS.PA_IND_RATE_SCHEDULES_PKG dependencies on DUAL

Line 23: from sys.dual

19: -- check against PA_PROJECT_TYPES_ALL
20: begin
21: select 1
22: into x_dummy
23: from sys.dual
24: where not exists
25: (select 1
26: from pa_project_types_all pt
27: where pt.cost_ind_rate_sch_id = x_ind_rate_sch_id

Line 48: from sys.dual

44: -- check against PA_PROJECTS_ALL
45: begin
46: select 1
47: into x_dummy
48: from sys.dual
49: where not exists
50: (select 1
51: from pa_projects_all p
52: where p.cost_ind_rate_sch_id = x_ind_rate_sch_id

Line 71: from sys.dual

67: -- check against PA_TASKS
68: begin
69: select 1
70: into x_dummy
71: from sys.dual
72: where not exists
73: (select 1
74: from pa_tasks t
75: where t.cost_ind_rate_sch_id = x_ind_rate_sch_id

Line 107: from sys.dual

103: -- check against capitalized Interest transactions
104: begin
105: select 1
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

Line 184: from sys.dual

180: -- check against PA_IND_RATE_SCH_REVISIONS
181: begin
182: select 1
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);