DBA Data[Home] [Help]

APPS.XTR_REPLICATE_BANK_BALANCES dependencies on XTR_ACCRLS_AMORT

Line 1161: xtr_deal_date_amounts dd, xtr_accrls_amort aa

1157: CURSOR c_accrl_deal IS
1158: SELECT max(period_to)
1159: FROM
1160: xtr_bank_balances bb, xtr_bank_accounts ba,
1161: xtr_deal_date_amounts dd, xtr_accrls_amort aa
1162: WHERE bb.company_code = p_company_code
1163: AND bb.account_number = p_account_number
1164: AND bb.company_code = ba.party_code
1165: AND bb.account_number = ba.account_number

Line 1724: xtr_deal_date_amounts dd, xtr_accrls_amort aa

1720: CURSOR c_accrl_deal IS
1721: SELECT max(period_to)
1722: FROM
1723: xtr_bank_balances bb, xtr_bank_accounts ba,
1724: xtr_deal_date_amounts dd, xtr_accrls_amort aa
1725: WHERE bb.company_code = p_company_code
1726: AND bb.account_number = p_account_number
1727: AND bb.company_code = ba.party_code
1728: AND bb.account_number = ba.account_number