APPS.PA_IND_COST_CODES_PKG dependencies on DUAL

Line 32: FROM dual

28: status := 0;
29:
30: SELECT count(1)
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 );

Line 44: FROM dual

40: status := 1;
41: ELSE -- Check for icc multipliers
42: SELECT count(1)
43: INTO dummy
44: FROM dual
45: WHERE EXISTS
46: ( SELECT 1
47: FROM pa_ind_cost_multipliers
48: WHERE ind_cost_code = X_icc_name );

Line 59: FROM dual

55: -- At least one icc multiplier exists; now check
56: -- for compiled multipliers
57: SELECT count(1)
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 );

Line 102: FROM dual

98: status := 0;
99:
100: SELECT 1
101: INTO dummy
102: FROM dual
103: WHERE NOT EXISTS
104: ( SELECT 1
105: FROM pa_ind_cost_codes
106: WHERE ind_cost_code = X_icc_name