APPS.GCS_AD_ENGINE dependencies on GCS_AD_TRIAL_BALANCES

Line 81: FROM GCS_AD_TRIAL_BALANCES

77: --Select a trial balance
78: --Sort the cursor by trial balance line number
79: cursor linesCursor (tbType varchar2) is
80: SELECT *
81: FROM GCS_AD_TRIAL_BALANCES
82: WHERE ad_transaction_id = xnsId
83: AND trial_balance_seq = tbType;
84:
85: Type xnsLinesTable is Table of linesCursor%ROWTYPE Index By binary_integer;

Line 131: gcs_ad_trial_balances b

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
135: and ata.ext_account_type_code = lia.dim_attribute_varchar_member