DBA Data[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on IBY_INTERMEDIARY_ACCTS

Line 9427: FROM iby_intermediary_accts

9423: check_digits) check_digits,
9424: nvl(l_new_intermed_acct1_rec.iban, iban) iban,
9425: object_version_number,
9426: dense_rank() over(ORDER BY intermediary_acct_id) rnk
9427: FROM iby_intermediary_accts
9428: WHERE bank_acct_id = l_account_id)
9429: WHERE rnk = 1;
9430:
9431: EXCEPTION

Line 9574: FROM iby_intermediary_accts

9570: check_digits) check_digits,
9571: nvl(l_new_intermed_acct2_rec.iban, iban) iban,
9572: object_version_number,
9573: dense_rank() over(ORDER BY intermediary_acct_id) rnk
9574: FROM iby_intermediary_accts
9575: WHERE bank_acct_id = l_account_id)
9576: WHERE rnk = 2;
9577:
9578: EXCEPTION