APPS.FTP_TP_PKG dependencies on FEM_DIM_ATTRIBUTES_B

Line 974: from fem_dim_attributes_b

970: select attribute_table_name into join_tbl_name
971: from fem_xdim_dimensions
972: where dimension_id = main_dim_id;
973: select attribute_value_column_name into attr_col_name
974: from fem_dim_attributes_b
975: where dimension_id = main_dim_id
976: and attribute_id = acct_type_attr_id;
977: where_clause := tbl_alias || '.line_item_id'
978: || '=' || tbl_join_alias || '.' || main_dim_col_name

Line 2761: select attribute_id into ACCT_TYPE_ATTR_ID from fem_dim_attributes_b

2757: begin
2758: -- initialize dimension_id
2759: select dimension_id into main_dim_id from fem_dimensions_b
2760: where dimension_varchar_label = 'LINE_ITEM';
2761: select attribute_id into ACCT_TYPE_ATTR_ID from fem_dim_attributes_b
2762: where attribute_varchar_label = 'EXTENDED_ACCOUNT_TYPE'
2763: and dimension_id = main_dim_id;
2764: -- ext_accuont_types values
2765: select dimension_id into ext_account_type_id from fem_dimensions_b

Line 2768: select attribute_id into asset_flag_id from fem_dim_attributes_b

2764: -- ext_accuont_types values
2765: select dimension_id into ext_account_type_id from fem_dimensions_b
2766: where dimension_varchar_label = EXT_ACCOUNT_TYPE_NAME;
2767: -- asset flag attribute id
2768: select attribute_id into asset_flag_id from fem_dim_attributes_b
2769: where dimension_id = ext_account_type_id
2770: and attribute_varchar_label = ASSET_FLAG_NAME;
2771: -- off_bal attribute
2772: select attribute_id into off_bal_flag_id from fem_dim_attributes_b

Line 2772: select attribute_id into off_bal_flag_id from fem_dim_attributes_b

2768: select attribute_id into asset_flag_id from fem_dim_attributes_b
2769: where dimension_id = ext_account_type_id
2770: and attribute_varchar_label = ASSET_FLAG_NAME;
2771: -- off_bal attribute
2772: select attribute_id into off_bal_flag_id from fem_dim_attributes_b
2773: where dimension_id = ext_account_type_id
2774: and attribute_varchar_label = OFF_BAL_NAME;
2775: end FTP_TP_PKG;