APPS.PA_COPY_STRUCTURE_PKG dependencies on PA_COST_BASE_COST_CODES

Line 49: (SELECT 1 FROM pa_cost_base_cost_codes

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
53: WHERE cost_plus_structure = cp_structure)

Line 93: FROM pa_cost_base_cost_codes

89: SELECT cost_base,
90: cost_base_type,
91: ind_cost_code,
92: precedence
93: FROM pa_cost_base_cost_codes
94: WHERE cost_plus_structure = source;
95:
96: CURSOR et_cursor
97: IS

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,

Line 143: INSERT INTO pa_cost_base_cost_codes

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,
146: cost_base,
147: cost_base_type,