APPS.XTR_EXP_SUMM_P dependencies on XTR_INTEREST_RATE_BANDS

Line 566: from XTR_INTEREST_RATE_BANDS

562: nvl(PERIOD_TO,'0')||decode(nvl(TYPE_PERIOD_TO_MONTH_YEAR,'M'),'M','Months','Years')) PERIOD_NAME,
563: add_months(trunc(count_months_from),decode(nvl(TYPE_PERIOD_FROM_MONTH_YEAR,'M'),'M',1,12)*nvl(PERIOD_FROM,0)) P_FROM,
564: decode(PERIOD_TO,NULL,to_date('01/01/2200','DD/MM/YYYY'),add_months(trunc(count_months_from),decode(nvl(TYPE_PERIOD_TO_MONTH_YEAR,'M'),'M',1,12)*PERIOD_TO)) P_TO,
565: FX_PERCENT_MAX,FX_PERCENT_MIN,period_desc
566: from XTR_INTEREST_RATE_BANDS
567: where currency like upper(nvl(p_sel_ccy,'%'))
568: and currency not in(select home_currency
569: from XTR_parties_v
570: where party_type='C');