DBA Data[Home] [Help]

APPS.PA_DRAFT_REVENUES_PKG dependencies on DUAL

Line 23: from sys.dual

19: else
20: begin
21: select null
22: into dummy
23: from sys.dual
24: where exists (
25: select null
26: from pa_draft_revenues
27: where project_id = X_project_id

Line 45: from sys.dual

41: draft_revenue_num = X_draft_revenue_num;
42: begin
43: select null
44: into dummy
45: from sys.dual
46: where not exists (
47: select null
48: from pa_draft_revenues
49: where project_id = X_project_id

Line 78: from sys.dual

74: else
75: begin
76: select null
77: into dummy
78: from sys.dual
79: where exists (
80: select null
81: from pa_draft_revenues
82: where project_id = X_project_id

Line 102: from sys.dual

98:
99: begin
100: select null
101: into dummy
102: from sys.dual
103: where not exists (
104: select null
105: from pa_draft_revenues
106: where project_id = X_project_id

Line 121: from sys.dual

117:
118: begin
119: select null
120: into dummy
121: from sys.dual
122: where not exists (
123: select null
124: from pa_draft_invoices
125: where (project_id, draft_invoice_num) in

Line 165: from sys.dual

161:
162: begin
163: select null
164: into dummy
165: from sys.dual
166: where not exists (
167: select null
168: from pa_draft_revenues
169: where project_id = X_project_id