DBA Data[Home] [Help]

APPS.GCS_AD_TRIALBALANCE_PKG dependencies on FEM_LN_ITEMS_ATTR

Line 611: fem_ln_items_attr flia

607: || ', last_update_date = sysdate,'
608: || g_nl
609: || ' line_type_code = decode((SELECT feata.dim_attribute_varchar_member
610: FROM fem_ext_acct_types_attr feata,
611: fem_ln_items_attr flia
612: WHERE gcs_entry_lines.line_item_id =
613: flia.line_item_id
614: AND flia.value_set_id =' ||
615: gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id || '

Line 640: fem_ln_items_attr flia

636: ytd_balance_e = NVL(ytd_debit_balance_e, 0) - NVL(ytd_credit_balance_e, 0),
637: line_type_code = decode(
638: (SELECT feata.dim_attribute_varchar_member
639: FROM fem_ext_acct_types_attr feata,
640: fem_ln_items_attr flia
641: WHERE gcs_entry_lines.line_item_id = flia.line_item_id
642: AND flia.value_set_id = l_line_item_vs_id
643: AND flia.attribute_id = l_ext_acct_type_attr
644: AND flia.version_id = l_ext_acct_type_version