APPS.PA_COST_BASES_PKG dependencies on PA_COST_BASE_EXP_TYPES

Line 79: from pa_cost_base_exp_types p

75: into x_dummy
76: from sys.dual
77: where not exists
78: (select 1
79: from pa_cost_base_exp_types p
80: where p.cost_base = x_cost_base);
81:
82: x_return_status := 0;
83:

Line 103: -- and PA_COST_BASE_EXP_TYPES. However we may not check these tables in

99: ----------------------------------------------------------------------------
100: ----------------------------------------------------------------------------
101: -- this procedure will do a referential integrity check. Cost base appears
102: -- as a FK in 3 tables, PA_COMPILED_MULTIPLIERS, PA_COST_BASE_COST_CODES
103: -- and PA_COST_BASE_EXP_TYPES. However we may not check these tables in
104: -- all cases as it may not be logically relevant. So we will check against
105: -- the following. We will check against PA_COST_BASE_EXP_TYPES and
106: -- PA_COST_BASE_COST_CODES.
107: -- Also if data exists in PA_COST_BASE_COST_CODES, we will check further

Line 105: -- the following. We will check against PA_COST_BASE_EXP_TYPES and

101: -- this procedure will do a referential integrity check. Cost base appears
102: -- as a FK in 3 tables, PA_COMPILED_MULTIPLIERS, PA_COST_BASE_COST_CODES
103: -- and PA_COST_BASE_EXP_TYPES. However we may not check these tables in
104: -- all cases as it may not be logically relevant. So we will check against
105: -- the following. We will check against PA_COST_BASE_EXP_TYPES and
106: -- PA_COST_BASE_COST_CODES.
107: -- Also if data exists in PA_COST_BASE_COST_CODES, we will check further
108: -- to see if the exp item has been costed.
109:

Line 186: from pa_cost_base_exp_types p

182: into x_dummy
183: from sys.dual
184: where not exists
185: (select 1
186: from pa_cost_base_exp_types p
187: where p.cost_base = x_cost_base
188: and p.cost_base_type = x_cost_base_type);
189:
190: x_return_status := 0;