APPS.PA_IND_COST_CODES_PKG dependencies on PA_COMPILED_MULTIPLIERS

Line 10: -- PA_COMPILED_MULTIPLIERS

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
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

Line 17: -- PA_COMPILED_MULTIPLIERS since the multiplier must first exist before it can

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
17: -- PA_COMPILED_MULTIPLIERS since the multiplier must first exist before it can
18: -- be compiled. IF a icc multiplier does exist, then this procedure checks
19: -- further to see if a compiled mutliplier exists.
20:
21: PROCEDURE check_references( X_icc_name IN VARCHAR2

Line 62: FROM pa_compiled_multipliers

58: INTO dummy
59: FROM dual
60: WHERE EXISTS
61: ( SELECT 1
62: FROM pa_compiled_multipliers
63: WHERE ind_cost_code = X_icc_name );
64:
65: IF ( dummy = 0 ) THEN
66: -- No compiled multipliers exist