APPS.FEM_ADMIN_UTIL_PKG dependencies on FEM_TABLE_CLASS_PROP

Line 1688: fem_table_prop_col_req tp, fem_table_class_prop tc

1684: r.data_length||', '||r.data_precision||', '||r.data_scale req_data_length,
1685: a.data_type col_data_type, r.data_type req_data_type,
1686: a.nullable col_nullable, tp.nullable_flag req_nullable
1687: FROM fem_tab_columns_b t, fem_column_requiremnt_b r, all_tab_columns a,
1688: fem_table_prop_col_req tp, fem_table_class_prop tc
1689: WHERE t.table_name = p_syn_name
1690: AND t.column_name = r.column_name
1691: AND a.table_name = p_db_name
1692: AND a.owner = p_tab_owner

Line 2190: FROM fem_table_class_prop c, fem_table_properties p

2186: 'fem.plsql.fem_admin_util_pkg.validate_tab_class';
2187:
2188: CURSOR c_class_prop (p_class VARCHAR2) IS
2189: SELECT p.table_property_code, p.property_type, p.column_req_type
2190: FROM fem_table_class_prop c, fem_table_properties p
2191: WHERE c.table_classification_code = p_class
2192: AND c.table_property_code = p.table_property_code
2193: AND p.property_type <> 'OTHER';
2194:

Line 2197: FROM fem_table_class_prop C,

2193: AND p.property_type <> 'OTHER';
2194:
2195: CURSOR c_procedure (p_class VARCHAR2) IS
2196: SELECT DISTINCT S.stored_procedure_name
2197: FROM fem_table_class_prop C,
2198: fem_table_prop_stp S
2199: WHERE C.table_classification_code = p_class
2200: AND C.table_property_code = S.table_property_code;
2201:

Line 2513: from fem_table_class_prop ftcp,

2509: FROM fnd_lookup_values_vl flv
2510: WHERE flv.lookup_type = 'FEM_TABLE_CLASSIFICATION_DSC'
2511: AND not exists(
2512: select ftcp.table_classification_code
2513: from fem_table_class_prop ftcp,
2514: fem_table_prop_stp ftps
2515: where ftcp.table_classification_code = flv.lookup_code
2516: and ftcp.table_property_code = ftps.table_property_code
2517: and ftps.stored_procedure_name in(

Line 2779: FROM fem_table_class_prop c, fem_table_properties p

2775: 'fem.plsql.fem_admin_util_pkg.validate_view_class';
2776:
2777: CURSOR c_class_prop (p_class VARCHAR2) IS
2778: SELECT p.table_property_code, p.property_type, p.column_req_type
2779: FROM fem_table_class_prop c, fem_table_properties p
2780: WHERE c.table_classification_code = p_class
2781: AND c.table_property_code = p.table_property_code
2782: AND p.property_type <> 'OTHER';
2783:

Line 2786: FROM fem_table_class_prop C,

2782: AND p.property_type <> 'OTHER';
2783:
2784: CURSOR c_procedure (p_class VARCHAR2) IS
2785: SELECT DISTINCT S.stored_procedure_name
2786: FROM fem_table_class_prop C,
2787: fem_table_prop_stp S
2788: WHERE C.table_classification_code = p_class
2789: AND C.table_property_code = S.table_property_code;
2790: