APPS.PA_COPY_STRUCTURE_PKG dependencies on DUAL

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

13: status := 0;
14:
15: -- check pa_cost_plus_structures table
16:
17: SELECT 1 INTO dummy FROM sys.dual WHERE EXISTS
18: (SELECT 1 FROM pa_cost_plus_structures
19: WHERE cost_plus_structure = cp_structure);
20:
21: exception

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

44: * The view pa_cost_base_v doesnot get merged here.
45: * Instead of the view, the query now directly looks into the
46: * base tables.
47: */
48: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
49: (SELECT 1 FROM pa_cost_base_cost_codes
50: WHERE cost_plus_structure = cp_structure)
51: AND NOT EXISTS
52: (SELECT 1 FROM pa_cost_base_exp_types

Line 141: SELECT pa_cost_base_cost_codes_s.nextval into cbicc_id FROM sys.dual;

137: end if;
138:
139:
140: for icc_row in icc_cursor loop
141: SELECT pa_cost_base_cost_codes_s.nextval into cbicc_id FROM sys.dual;
142:
143: INSERT INTO pa_cost_base_cost_codes
144: (cost_base_cost_code_id,
145: cost_plus_structure,