DBA Data[Home] [Help]

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on JA_CN_ACCOUNT_BALANCES_V

Line 1140: FROM ja_cn_account_balances_v jcab

1136: --Cursor for fetching balance at itemization level
1137: CURSOR balance_cur IS
1138: SELECT SUM(func_end_balance) Functional_Balance,
1139: SUM(orig_end_balance) Entered_Balance
1140: FROM ja_cn_account_balances_v jcab
1141: WHERE jcab.ledger_id = pn_ledger_id --parameter: pn_ledger_id
1142: AND jcab.legal_entity_id = pn_legal_entity_id --parameter: pn_legal_entity_id
1143: AND jcab.third_party_id = pn_supplier_id --parameter: pn_supplier_id
1144: AND jcab.account_segment = pv_account_number --parameter: pv_account_number