DBA Data[Home] [Help]

APPS.GCS_AD_ENGINE dependencies on FEM_EXT_ACCT_TYPES_ATTR

Line 130: fem_ext_acct_types_attr ata,

126: --Find the net asset value
127: cursor navCursor(ataAtt NUMBER, ataVers NUMBER, liaAtt NUMBER, liaVers NUMBER) Is
128: Select b.trial_balance_seq, sum( nvl(b.debit_amount,0) - nvl(b.credit_amount,0) )
129: from fem_ln_items_attr lia,
130: fem_ext_acct_types_attr ata,
131: gcs_ad_trial_balances b
132: where lia.dim_attribute_varchar_member in ('ASSET', 'LIABILITY')
133: and ata.attribute_id = ataAtt
134: and ata.version_id = ataVers

Line 656: FROM fem_ext_acct_types_attr feata,

652: IF (l_entry_id IS NOT NULL) THEN
653: UPDATE gcs_entry_lines gel
654: SET line_type_code = DECODE(
655: (SELECT feata.dim_attribute_varchar_member
656: FROM fem_ext_acct_types_attr feata,
657: fem_ln_items_attr flia
658: WHERE gel.line_item_id = flia.line_item_id
659: AND flia.value_set_id = l_line_item_vs_id
660: AND flia.attribute_id = l_ext_acct_type_attr