DBA Data[Home] [Help]

APPS.PA_BILLING_EXTENSIONS_PKG dependencies on DUAL

Line 17: from sys.dual

13: begin
14: --
15: select 1
16: into x_dummy
17: from sys.dual
18: where not exists
19: (select 1
20: from pa_billing_extensions
21: where name = x_name

Line 45: from sys.dual

41: begin
42: --
43: select 1
44: into x_dummy
45: from sys.dual
46: where not exists
47: (select 1
48: from pa_billing_extensions
49: where processing_order = x_order

Line 75: from sys.dual

71: stage := 1;
72: --
73: select 1
74: into x_dummy
75: from sys.dual
76: where not exists
77: ( select 1
78: from pa_billing_assignments
79: where billing_extension_id = x_bill_extension_id );

Line 105: from sys.dual

101: --
102: stage := 1;
103: --
104: select 1 into x_dummy
105: from sys.dual
106: where not exists ( select 1
107: from pa_billing_assignments
108: where billing_extension_id = x_bill_extension_id
109: and billing_assignment_id in

Line 132: from sys.dual;

128: --
129: begin
130: --
131: select pa_billing_extensions_s.nextval into x_nextval
132: from sys.dual;
133: --
134: x_return_status := 0;
135: --
136: EXCEPTION