DBA Data[Home] [Help]

APPS.XTR_MARKET_DATA_P dependencies on XTR_RM_MD_SET_CURVES

Line 1051: 1. Look at DATA_SIDE from XTR_RM_MD_SET_CURVES

1047: Else
1048: Assumed to for FX volatility
1049:
1050: The ordering priority of the data side (bid, ask, mid):
1051: 1. Look at DATA_SIDE from XTR_RM_MD_SET_CURVES
1052: 2. Case 1: If DATA_SIDE from XTR_RM_MD_SET_CURVES =
1053: 'DEFAULT' then look at DATA_SIDE from XTR_RM_MD_CURVES
1054: Case 2 : If the DATA_SIDE from XTR_RM_MD_SET_CURVES =
1055: 'BID/ASK' then look at p_side (passed parameter)

Line 1052: 2. Case 1: If DATA_SIDE from XTR_RM_MD_SET_CURVES =

1048: Assumed to for FX volatility
1049:
1050: The ordering priority of the data side (bid, ask, mid):
1051: 1. Look at DATA_SIDE from XTR_RM_MD_SET_CURVES
1052: 2. Case 1: If DATA_SIDE from XTR_RM_MD_SET_CURVES =
1053: 'DEFAULT' then look at DATA_SIDE from XTR_RM_MD_CURVES
1054: Case 2 : If the DATA_SIDE from XTR_RM_MD_SET_CURVES =
1055: 'BID/ASK' then look at p_side (passed parameter)
1056: 3. If in Case 1 the DATA_SIDE from XTR_RM_MD_CURVES =

Line 1054: Case 2 : If the DATA_SIDE from XTR_RM_MD_SET_CURVES =

1050: The ordering priority of the data side (bid, ask, mid):
1051: 1. Look at DATA_SIDE from XTR_RM_MD_SET_CURVES
1052: 2. Case 1: If DATA_SIDE from XTR_RM_MD_SET_CURVES =
1053: 'DEFAULT' then look at DATA_SIDE from XTR_RM_MD_CURVES
1054: Case 2 : If the DATA_SIDE from XTR_RM_MD_SET_CURVES =
1055: 'BID/ASK' then look at p_side (passed parameter)
1056: 3. If in Case 1 the DATA_SIDE from XTR_RM_MD_CURVES =
1057: 'BID/ASK' then look at p_side (passed parameter).
1058:

Line 1135: FROM xtr_rm_md_set_curves sc, xtr_rm_md_curves c

1131: CURSOR get_curve_code IS
1132: SELECT c.curve_code, DECODE(sc.data_side, 'DEFAULT', p_in_rec.p_side, 'BID/ASK', p_in_rec.p_side, sc.data_side) side,
1133: DECODE(sc.interpolation, 'DEFAULT', c.default_interpolation,
1134: sc.interpolation) interpolation
1135: FROM xtr_rm_md_set_curves sc, xtr_rm_md_curves c
1136: WHERE sc.set_code = p_in_rec.p_md_set_code
1137: AND c.type = DECODE(p_in_rec.p_indicator,'V','IRVOL', 'YIELD')
1138: AND c.ccy = p_in_rec.p_ccy
1139: AND sc.curve_code = c.curve_code;

Line 1148: FROM xtr_rm_md_set_curves sc, xtr_rm_md_curves c

1144: CURSOR get_curve_code_v IS
1145: SELECT c.curve_code, DECODE(sc.data_side, 'DEFAULT', p_in_rec.p_side, 'BID/ASK', p_in_rec.p_side, sc.data_side) side,
1146: DECODE(sc.interpolation, 'DEFAULT', c.default_interpolation,
1147: sc.interpolation) interpolation
1148: FROM xtr_rm_md_set_curves sc, xtr_rm_md_curves c
1149: WHERE sc.set_code = p_in_rec.p_md_set_code
1150: AND c.type = 'FXVOL'
1151: AND ((c.ccy = p_in_rec.p_ccy AND c.contra_ccy = p_in_rec.p_contra_ccy)
1152: OR (c.ccy = p_in_rec.p_contra_ccy AND c.contra_ccy = p_in_rec.p_ccy))