APPS.PA_COST_BASE_VIEW_PKG dependencies on PA_COST_BASE_COST_CODES

Line 24: (SELECT 1 FROM pa_cost_base_cost_codes cbv

20: * the view pa_cost_base_v does not get merged.
21: * The query looks into the base tables instead of the view.
22: */
23: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
24: (SELECT 1 FROM pa_cost_base_cost_codes 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

Line 84: -- check pa_cost_base_cost_codes table

80: begin
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

Line 87: (SELECT 1 FROM pa_cost_base_cost_codes cbicc,

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)
90: and (cbicc.cost_base = c_base)
91: and (cbicc.cost_base_type = c_base_type))

Line 114: DELETE pa_cost_base_cost_codes

110: c_base_type IN varchar2,
111: status IN OUT NOCOPY number)
112: is
113: begin
114: DELETE pa_cost_base_cost_codes
115: WHERE cost_plus_structure = cp_structure
116: AND cost_base = c_base
117: AND cost_base_type = c_base_type;
118: