APPS.PA_COST_PLUS_STRUCTURE_PKG dependencies on DUAL

Line 15: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS

11: begin
12:
13: status := 0;
14:
15: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
16: (SELECT 1 FROM pa_cost_plus_structures
17: WHERE cost_plus_structure = cp_structure);
18:
19: exception

Line 39: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS

35:
36: -- check pa_cost_base_cost_codes table
37: -- check pa_cost_base_exp_types table
38:
39: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
40: (SELECT 1 FROM pa_cost_base_cost_codes cbicc,
41: pa_cost_base_exp_types cbet
42: WHERE cbicc.cost_plus_structure = cp_structure
43: OR cbet.cost_plus_structure = cp_structure);

Line 66: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS

62: status := 0;
63:
64: -- check pa_ind_rate_sch_revisions table
65:
66: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
67: (SELECT 1 FROM pa_ind_rate_sch_revisions irsr
68: WHERE irsr.cost_plus_structure = cp_structure);
69:
70: exception

Line 89: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS

85: begin
86:
87: status := 0;
88:
89: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
90: (SELECT 1
91: FROM pa_ind_rate_schedules
92: WHERE cost_plus_structure = cp_structure);
93:

Line 113: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS

109: begin
110:
111: status := 0;
112:
113: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
114: (SELECT 1
115: FROM pa_cost_base_cost_codes
116: WHERE cost_plus_structure = cp_structure);
117:

Line 136: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS

132: begin
133:
134: status := 0;
135:
136: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
137: (SELECT 1
138: FROM pa_cost_plus_structures
139: WHERE default_for_override_sch_flag = 'Y');
140:

Line 175: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS

171: -- Cases A, C, D, and E violate that only one default structure can exist
172: -- any point of time.
173: -- Case B and F are acceptable.
174:
175: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
176: (SELECT 1 FROM pa_cost_plus_structures cps
177: WHERE cps.default_for_override_sch_flag = 'Y'
178: AND ( -- case A
179: ( (TRUNC(cps.start_date_active)