APPS.PA_COST_BASE_VIEW_PKG dependencies on DUAL

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

19: * Performance related changes:
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)

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

49: begin
50:
51: status := 0;
52:
53: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
54: (SELECT 1
55: FROM pa_ind_rate_sch_revisions
56: WHERE cost_plus_structure = cp_structure
57: AND compiled_date IS NOT NULL);

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

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