APPS.AMW_PROCCERT_EVENT_PVT dependencies on FND_FLEX_VALUE_SETS

Line 121: from fnd_flex_value_sets

117: AND cert.certification_id = c_cert_id;
118:
119: CURSOR c_fch_vs_id IS
120: select flex_value_set_id
121: from fnd_flex_value_sets
122: where flex_value_set_name = 'FCH_ICM_ENTITY_VALUE_SET';
123:
124: l_cert_id NUMBER;
125: l_org_id NUMBER;

Line 314: from fnd_flex_value_sets

310: AND cert.object_type = 'PROCESS');
311:
312: CURSOR c_fch_vs_id IS
313: select flex_value_set_id
314: from fnd_flex_value_sets
315: where flex_value_set_name = 'FCH_ICM_ENTITY_VALUE_SET';
316:
317:
318: M_org_ineff_proc number;

Line 1348: from fnd_flex_value_sets

1344: AND object_id = PRIOR parent_object_id);
1345:
1346: CURSOR c_fch_vs_id IS
1347: select flex_value_set_id
1348: from fnd_flex_value_sets
1349: where flex_value_set_name = 'FCH_ICM_ENTITY_VALUE_SET';
1350:
1351: M_dashbd_org_pending_cert number;
1352: M_dashbd_org_proc_cert_issues number;