APPS.PA_COPY_STRUCTURE_PKG dependencies on PA_COST_BASE_EXP_TYPES

Line 52: (SELECT 1 FROM pa_cost_base_exp_types

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)
54: ;
55:
56: exception

Line 101: FROM pa_cost_base_exp_types

97: IS
98: SELECT cost_base,
99: cost_base_type,
100: expenditure_type
101: FROM pa_cost_base_exp_types
102: WHERE cost_plus_structure = source;
103:
104: -- Local variables
105: cbicc_id number;

Line 175: INSERT INTO pa_cost_base_exp_types

171: stage := 200;
172:
173: for et_row in et_cursor loop
174:
175: INSERT INTO pa_cost_base_exp_types
176: (cost_plus_structure,
177: cost_base,
178: cost_base_type,
179: expenditure_type,