DBA Data[Home] [Help]

APPS.FTP_TP_PKG dependencies on FEM_DIMENSIONS_B

Line 2759: select dimension_id into main_dim_id from fem_dimensions_b

2755:
2756:
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;

Line 2765: select dimension_id into ext_account_type_id from fem_dimensions_b

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
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