APPS.QRM_PA_AGGREGATION_P dependencies on QRM_CURRENT_DEALS_V

Line 84: qrm_current_deals_v v

80: AND da.deal_calc_id=dc.deal_calc_id;
81: CURSOR check_base_ccy IS
82: SELECT DISTINCT v.base_ccy
83: FROM qrm_deal_calculations dc, qrm_deals_analyses da,
84: qrm_current_deals_v v
85: WHERE da.analysis_name=p_name
86: AND da.deal_calc_id=dc.deal_calc_id
87: AND v.deal_no=dc.deal_no
88: AND v.transaction_no=dc.transaction_no;

Line 92: qrm_current_deals_v v

88: AND v.transaction_no=dc.transaction_no;
89: CURSOR check_contra_ccy IS
90: SELECT DISTINCT v.contra_ccy
91: FROM qrm_deal_calculations dc, qrm_deals_analyses da,
92: qrm_current_deals_v v
93: WHERE da.analysis_name=p_name
94: AND da.deal_calc_id=dc.deal_calc_id
95: AND v.deal_no=dc.deal_no
96: AND v.transaction_no=dc.transaction_no;

Line 100: qrm_current_deals_v v

96: AND v.transaction_no=dc.transaction_no;
97: CURSOR check_buy_ccy IS
98: SELECT DISTINCT v.buy_ccy
99: FROM qrm_deal_calculations dc, qrm_deals_analyses da,
100: qrm_current_deals_v v
101: WHERE da.analysis_name=p_name
102: AND da.deal_calc_id=dc.deal_calc_id
103: AND dc.deal_no=v.deal_no
104: AND dc.transaction_no=v.transaction_no;

Line 108: qrm_current_deals_v v

104: AND dc.transaction_no=v.transaction_no;
105: CURSOR check_sell_ccy IS
106: SELECT DISTINCT v.sell_ccy
107: FROM qrm_deal_calculations dc, qrm_deals_analyses da,
108: qrm_current_deals_v v
109: WHERE da.analysis_name=p_name
110: AND da.deal_calc_id=dc.deal_calc_id
111: AND dc.deal_no=v.deal_no
112: AND dc.transaction_no=v.transaction_no;

Line 116: qrm_current_deals_v v

112: AND dc.transaction_no=v.transaction_no;
113: CURSOR check_foreign_ccy IS
114: SELECT DISTINCT v.foreign_ccy
115: FROM qrm_deal_calculations dc, qrm_deals_analyses da,
116: qrm_current_deals_v v
117: WHERE da.analysis_name=p_name
118: AND da.deal_calc_id=dc.deal_calc_id
119: AND dc.deal_no=v.deal_no
120: AND dc.transaction_no=v.transaction_no;

Line 124: qrm_current_deals_v v

120: AND dc.transaction_no=v.transaction_no;
121: CURSOR check_domestic_ccy IS
122: SELECT DISTINCT v.domestic_ccy
123: FROM qrm_deal_calculations dc, qrm_deals_analyses da,
124: qrm_current_deals_v v
125: WHERE da.analysis_name=p_name
126: AND da.deal_calc_id=dc.deal_calc_id
127: AND dc.deal_no=v.deal_no
128: AND dc.transaction_no=v.transaction_no;

Line 132: qrm_current_deals_v v

128: AND dc.transaction_no=v.transaction_no;
129: CURSOR check_sensitivity_ccy IS
130: SELECT DISTINCT v.sensitivity_ccy
131: FROM qrm_deal_calculations dc, qrm_deals_analyses da,
132: qrm_current_deals_v v
133: WHERE da.analysis_name=p_name
134: AND da.deal_calc_id=dc.deal_calc_id
135: AND dc.deal_no=v.deal_no
136: AND dc.transaction_no=v.transaction_no;

Line 966: v_from VARCHAR2(100):=' FROM qrm_deal_calculations dc,qrm_deals_analyses da,qrm_current_deals_v v';

962: v_origin_usd SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
963: v_nom_fl_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
964: v_denom_fl_usd SYSTEM.QRM_VARCHAR240_TABLE := SYSTEM.QRM_VARCHAR240_TABLE();
965: v_num_denom_origin_usd SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
966: v_from VARCHAR2(100):=' FROM qrm_deal_calculations dc,qrm_deals_analyses da,qrm_current_deals_v v';
967: v_where VARCHAR2(255):=' WHERE da.deal_calc_id=dc.deal_calc_id AND da.analysis_name=:analysis_name AND dc.deal_no=v.deal_no AND dc.transaction_no=v.transaction_no';
968: i NUMBER(5);
969: j NUMBER(5);
970: v_aggregate_level NUMBER(5);