DBA Data[Home] [Help]

APPS.FND_ID_FLEX_SEGMENTS_PKG dependencies on FND_ID_FLEXS

Line 511: l_id_flex_code fnd_id_flexs.id_flex_code%TYPE;

507: x_form_above_prompt IN VARCHAR2,
508: x_description IN VARCHAR2)
509: IS
510: l_application_id NUMBER;
511: l_id_flex_code fnd_id_flexs.id_flex_code%TYPE;
512: l_id_flex_num NUMBER;
513: l_flex_value_set_id NUMBER := NULL;
514: l_rowid VARCHAR2(64);
515: BEGIN

Line 523: FROM fnd_id_flexs

519: WHERE application_short_name = x_application_short_name;
520:
521: SELECT id_flex_code
522: INTO l_id_flex_code
523: FROM fnd_id_flexs
524: WHERE application_id = l_application_id
525: AND id_flex_code = x_id_flex_code;
526:
527: SELECT id_flex_num