DBA Data[Home] [Help]

APPS.XTR_LIMITS_P dependencies on XTR_FX_PERIOD_WEIGHTINGS

Line 22: from XTR_FX_PERIOD_WEIGHTINGS c

18: cursor c_get_weighting (pc_deal_type VARCHAR2,
19: pc_deal_subtype VARCHAR2,
20: pc_amount_date date) is
21: select nvl(c.LIMIT_WEIGHTING / 100,1)
22: from XTR_FX_PERIOD_WEIGHTINGS c
23: where c.DEAL_TYPE = pc_deal_type
24: and c.DEAL_SUBTYPE = pc_deal_subtype
25: and c.NOS_MONTHS =
26: (select max(d.NOS_MONTHS)

Line 27: from XTR_FX_PERIOD_WEIGHTINGS d

23: where c.DEAL_TYPE = pc_deal_type
24: and c.DEAL_SUBTYPE = pc_deal_subtype
25: and c.NOS_MONTHS =
26: (select max(d.NOS_MONTHS)
27: from XTR_FX_PERIOD_WEIGHTINGS d
28: where d.DEAL_TYPE = c.DEAL_TYPE
29: and d.DEAL_SUBTYPE = c.DEAL_SUBTYPE
30: and d.NOS_MONTHS <= decode(sign(months_between(trunc(pc_amount_date),trunc(sysdate)))
31: ,-1,0