APPS.POA_CM_EVAL_SCORES_ICX dependencies on POA_CM_DISTRIBUTIONS

Line 52: from poa_cm_distributions

48: l_progress := '001';
49:
50: open c_Criteria for
51: select criteria_code, weight, min_score, max_score
52: from poa_cm_distributions
53: where category_id = nvl(p_category_id, -1)
54: and organization_id = nvl(p_oper_unit_id, -1)
55: order by criteria_code;
56:

Line 81: from poa_cm_distributions

77: l_progress := '004';
78:
79: open c_Criteria for
80: select criteria_code, weight, min_score, max_score
81: from poa_cm_distributions
82: where category_id = nvl(p_category_id, -1)
83: and organization_id is null
84: order by criteria_code;
85:

Line 92: from poa_cm_distributions

88: l_progress := '005';
89:
90: open c_Criteria for
91: select criteria_code, weight, min_score, max_score
92: from poa_cm_distributions
93: where organization_id = nvl(p_oper_unit_id, -1)
94: and category_id is null
95: order by criteria_code;
96:

Line 123: from poa_cm_distributions

119: l_progress := '008';
120:
121: open c_Criteria for
122: select criteria_code, weight, min_score, max_score
123: from poa_cm_distributions
124: where organization_id = nvl(p_oper_unit_id, -1)
125: and category_id is null
126: order by criteria_code;
127:

Line 134: from poa_cm_distributions

130: l_progress := '009';
131:
132: open c_Criteria for
133: select criteria_code, weight, min_score, max_score
134: from poa_cm_distributions
135: where category_id = nvl(p_category_id, -1)
136: and organization_id is null
137: order by criteria_code;
138:

Line 161: from poa_cm_distributions

157: if (l_index = 0) then
158:
159: open c_Criteria for
160: select criteria_code, weight, min_score, max_score
161: from poa_cm_distributions
162: where category_id is null
163: and organization_id is null
164: order by criteria_code;
165: