DBA Data[Home] [Help]

APPS.FND_FLEX_DESCVAL dependencies on FND_APPLICATION

Line 932: FROM fnd_application fa,

928: l_default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE;
929: BEGIN
930: SELECT fdfv.default_context_value
931: INTO l_default_context_value
932: FROM fnd_application fa,
933: fnd_descriptive_flexs_vl fdfv
934: WHERE fa.application_short_name = p_application_short_name
935: AND fdfv.application_id = fa.application_id
936: AND fdfv.descriptive_flexfield_name = p_descriptive_flexfield_name;

Line 958: FROM fnd_application fa,

954:
955: BEGIN
956: SELECT fdfv.default_context_value, fdfv.default_context_field_name
957: INTO l_default_context_value, l_default_context_field_name
958: FROM fnd_application fa,
959: fnd_descriptive_flexs_vl fdfv
960: WHERE fa.application_short_name = p_application_short_name
961: AND fdfv.application_id = fa.application_id
962: AND fdfv.descriptive_flexfield_name = p_descriptive_flexfield_name;

Line 971: FROM fnd_application fa,

967: FND_PROFILE.get(UPPER(SUBSTR(l_default_context_field_name, 13)), bind_val);
968: BEGIN
969: SELECT ctx.descriptive_flex_context_code
970: INTO l_default_context_value
971: FROM fnd_application fa,
972: fnd_descr_flex_contexts ctx
973: WHERE fa.application_short_name = p_application_short_name
974: AND fa.application_id = ctx.application_id
975: AND ctx.descriptive_flexfield_name = p_descriptive_flexfield_name