DBA Data[Home] [Help]

APPS.XTR_COMMON_FUNCTIONS dependencies on XTR_ACCRLS_AMORT

Line 449: FROM xtr_accrls_amort

445: BEGIN
446: IF p_deal_type in ('TMM','IRS') AND p_date is not null THEN
447: SELECT max(period_to)
448: INTO l_period_end
449: FROM xtr_accrls_amort
450: WHERE deal_no=p_deal_number
451: AND period_to > p_date;
452:
453: IF l_period_end IS NOT NULL THEN

Line 462: FROM Xtr_Accrls_Amort

458:
459: ELSE
460: SELECT count(deal_no)
461: INTO l_accrual_check
462: FROM Xtr_Accrls_Amort
463: WHERE deal_no = nvl(p_deal_number,deal_no)
464: AND Trans_no = nvl(p_transaction_number,Trans_no);
465:
466: IF l_accrual_check = 0 THEN