APPS.PA_IND_COST_CODES_PKG dependencies on PA_COST_BASE_COST_CODES

Line 8: -- PA_COST_BASE_COST_CODES

4: -- =====================================================================
5: -- This procedure performs a referential integrity check for indirect cost
6: -- codes. Indirect cost code appears as a foreign key in the following
7: -- tables:
8: -- PA_COST_BASE_COST_CODES
9: -- PA_IND_COST_CODE_MULTIPLIERS
10: -- PA_COMPILED_MULTIPLIERS
11: -- The procedure first checks if the icc is referenced in
12: -- PA_COST_BASE_COST_CODES. If it is, the outcome parameter is set to the

Line 12: -- PA_COST_BASE_COST_CODES. If it is, the outcome parameter is set to the

8: -- PA_COST_BASE_COST_CODES
9: -- PA_IND_COST_CODE_MULTIPLIERS
10: -- PA_COMPILED_MULTIPLIERS
11: -- The procedure first checks if the icc is referenced in
12: -- PA_COST_BASE_COST_CODES. If it is, the outcome parameter is set to the
13: -- relevant error message name and processing stops. If it is not, then the
14: -- procedure then checks for references in PA_IND_COST_CODE_MULTIPLIERS. If
15: -- the icc is not referenced in this table, then the outcome parameter is set
16: -- to NULL and processing stops; there is no need to check

Line 35: FROM pa_cost_base_cost_codes

31: INTO dummy
32: FROM dual
33: WHERE EXISTS
34: ( SELECT 1
35: FROM pa_cost_base_cost_codes
36: WHERE ind_cost_code = X_icc_name );
37:
38: IF ( dummy = 1 ) THEN -- ICC referenced by at least one cost base
39: outcome := 'PA_ICC_IN_COST_BASE';