APPS.PA_COST_BASE_VIEW_PKG dependencies on PA_COST_BASE_EXP_TYPES

Line 29: (SELECT 1 FROM pa_cost_base_exp_types cbv

25: WHERE cbv.cost_base = c_base
26: AND cbv.cost_base_type = c_base_type
27: AND cbv.cost_plus_structure = cp_structure)
28: AND NOT EXISTS
29: (SELECT 1 FROM pa_cost_base_exp_types cbv
30: WHERE cbv.cost_base = c_base
31: AND cbv.cost_base_type = c_base_type
32: AND cbv.cost_plus_structure = cp_structure);
33:

Line 85: -- check pa_cost_base_exp_types table

81:
82: status := 0;
83:
84: -- check pa_cost_base_cost_codes table
85: -- check pa_cost_base_exp_types table
86: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
87: (SELECT 1 FROM pa_cost_base_cost_codes cbicc,
88: pa_cost_base_exp_types cbet
89: WHERE ( (cbicc.cost_plus_structure = cp_structure)

Line 88: pa_cost_base_exp_types cbet

84: -- check pa_cost_base_cost_codes table
85: -- check pa_cost_base_exp_types table
86: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
87: (SELECT 1 FROM pa_cost_base_cost_codes cbicc,
88: pa_cost_base_exp_types cbet
89: WHERE ( (cbicc.cost_plus_structure = cp_structure)
90: and (cbicc.cost_base = c_base)
91: and (cbicc.cost_base_type = c_base_type))
92: or ( (cbet.cost_plus_structure = cp_structure)

Line 119: DELETE pa_cost_base_exp_types

115: WHERE cost_plus_structure = cp_structure
116: AND cost_base = c_base
117: AND cost_base_type = c_base_type;
118:
119: DELETE pa_cost_base_exp_types
120: WHERE cost_plus_structure = cp_structure
121: AND cost_base = c_base
122: AND cost_base_type = c_base_type;
123: