APPS.PA_COST_PLUS_STRUCTURE_PKG dependencies on PA_COST_BASE_EXP_TYPES

Line 37: -- check pa_cost_base_exp_types table

33:
34: status := 0;
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

Line 41: pa_cost_base_exp_types cbet

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);
44:
45: exception

Line 281: DELETE pa_cost_base_exp_types

277:
278: DELETE pa_cost_base_cost_codes
279: WHERE cost_plus_structure = cp_structure;
280:
281: DELETE pa_cost_base_exp_types
282: WHERE cost_plus_structure = cp_structure;
283:
284: COMMIT;
285:

Line 298: UPDATE pa_cost_base_exp_types

294: UPDATE pa_cost_base_cost_codes
295: SET cost_plus_structure = new_cp_structure
296: WHERE cost_plus_structure = old_cp_structure;
297:
298: UPDATE pa_cost_base_exp_types
299: SET cost_plus_structure = new_cp_structure
300: WHERE cost_plus_structure = old_cp_structure;
301:
302: COMMIT;