APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_COLUMNS

Line 2445: SELECT fnd_columns.column_type

2441: l_maximum_size NUMBER;
2442: l_flex_value_set_id NUMBER;
2443: l_format_mask VARCHAR2(30);
2444: BEGIN
2445: SELECT fnd_columns.column_type
2446: INTO l_datatype
2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id

Line 2447: FROM fnd_columns,fnd_tables,fnd_id_flexs

2443: l_format_mask VARCHAR2(30);
2444: BEGIN
2445: SELECT fnd_columns.column_type
2446: INTO l_datatype
2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name

Line 2448: WHERE fnd_columns.column_name = p_column_name

2444: BEGIN
2445: SELECT fnd_columns.column_type
2446: INTO l_datatype
2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id

Line 2449: AND fnd_columns.table_id = fnd_tables.table_id

2445: SELECT fnd_columns.column_type
2446: INTO l_datatype
2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code

Line 2450: AND fnd_columns.application_id = fnd_tables.application_id

2446: INTO l_datatype
2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code
2454: AND fnd_id_flexs.application_id = l_kff_flx.application_id;