eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QRM_PA_CALCULATION_P dependencies on QRM_CURRENT_DEALS_V

Line 224: from qrm_current_deals_v.

220:
221: /*---------------------------------------------------------------------
222: Cursors that access xtr_rollover_transactions_v, xtr_deals_v
223: access valid deals because those deals numbers are first derived
224: from qrm_current_deals_v.
225: ----------------------------------------------------------------------*/
226:
227: -- gets current transaction
228: CURSOR get_tmm_irs_rtmm_curr_trans(p_deal_no NUMBER,

Line 284: p_from_where_clause VARCHAR2(3000) := ' FROM qrm_current_deals_v'||' WHERE ((deal_type<>''IG'' and (deal_type<>''BOND'' or (deal_type=''BOND'' and face_value<>0)) and (end_date is null or end_date >= '''||p_ref_date||''')) ';

280: -- IG deals: deal numbers recycled, ie. reused by using new trans numbers
281: -- max trans number is the current one
282: -- max trans number has balance=0 and interest is settled, deal is closed
283: -- ONC: if principal adjust (mapped to start date)=0, exclude trans
284: p_from_where_clause VARCHAR2(3000) := ' FROM qrm_current_deals_v'||' WHERE ((deal_type<>''IG'' and (deal_type<>''BOND'' or (deal_type=''BOND'' and face_value<>0)) and (end_date is null or end_date >= '''||p_ref_date||''')) ';
285:
286: --start bug 2804548
287: p_next_coupon_reset DATE;
288: p_discount_factors_add1bp XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();

Line 959: IN (select deal_no, max(transaction_no) from qrm_current_deals_v where NOT(accrued_interest=interest_settled

955: p_select_clause := p_select_clause||'quantity_remaining, rounding_type, day_count_type, prepaid_interest ';
956:
957: /* RVALLAMS Bug 3007749
958: p_from_where_clause := p_from_where_clause||'OR (deal_type=''IG'' and (deal_no, transaction_no)
959: IN (select deal_no, max(transaction_no) from qrm_current_deals_v where NOT(accrued_interest=interest_settled
960: and face_value=0) group by deal_no)))';
961: */
962:
963: -- RVALLAMS Bug 3805685 added group by deal_no clause

Line 965: p_from_where_clause := p_from_where_clause||' OR (deal_type=''IG'' and (deal_no, transaction_no) IN (select deal_no, max(transaction_no) from qrm_current_deals_v b where ';

961: */
962:
963: -- RVALLAMS Bug 3805685 added group by deal_no clause
964:
965: p_from_where_clause := p_from_where_clause||' OR (deal_type=''IG'' and (deal_no, transaction_no) IN (select deal_no, max(transaction_no) from qrm_current_deals_v b where ';
966: p_from_where_clause := p_from_where_clause||' (deal_no,deal_date) = (select deal_no,max(deal_date) from qrm_current_deals_v c where b.deal_no = c.deal_no group by deal_no) group by b.deal_no) ';
967: p_from_where_clause := p_from_where_clause||' AND NOT(NVL(accrued_interest,0)=NVL(interest_settled,0) and face_value=0)))';
968:
969: -- '0' : completed successfully --|

Line 966: p_from_where_clause := p_from_where_clause||' (deal_no,deal_date) = (select deal_no,max(deal_date) from qrm_current_deals_v c where b.deal_no = c.deal_no group by deal_no) group by b.deal_no) ';

962:
963: -- RVALLAMS Bug 3805685 added group by deal_no clause
964:
965: p_from_where_clause := p_from_where_clause||' OR (deal_type=''IG'' and (deal_no, transaction_no) IN (select deal_no, max(transaction_no) from qrm_current_deals_v b where ';
966: p_from_where_clause := p_from_where_clause||' (deal_no,deal_date) = (select deal_no,max(deal_date) from qrm_current_deals_v c where b.deal_no = c.deal_no group by deal_no) group by b.deal_no) ';
967: p_from_where_clause := p_from_where_clause||' AND NOT(NVL(accrued_interest,0)=NVL(interest_settled,0) and face_value=0)))';
968:
969: -- '0' : completed successfully --|
970: -- '1' : completed with warnings |--->corresponds to CM codes

Line 1981: ELSE -- other deals: gap date already mapped in qrm_current_deals_v

1977: p_gap_date_temp(i) := NVL(p_maturity_dates(i), p_ref_date+1);
1978: END IF;
1979: ELSIF (p_deal_types(i)='IG') THEN
1980: p_gap_date_temp(i) := p_ref_date+1;
1981: ELSE -- other deals: gap date already mapped in qrm_current_deals_v
1982: p_gap_date_temp(i) := p_gap_dates(i);
1983: END IF;
1984: END IF;
1985: IF (g_proc_level>=g_debug_level) THEN

Line 6915: FROM qrm_current_deals_v

6911: WHERE deal_number=p_deal_no;
6912:
6913: /* CURSOR get_deal_data IS
6914: SELECT max(maturity_date), settle_date
6915: FROM qrm_current_deals_v
6916: GROUP BY deal_no, settle_date
6917: HAVING deal_no=p_deal_no; Bug 4965436*/
6918:
6919: CURSOR get_deal_data IS

Line 6921: FROM qrm_current_deals_v

6917: HAVING deal_no=p_deal_no; Bug 4965436*/
6918:
6919: CURSOR get_deal_data IS
6920: SELECT max(maturity_date), settle_date
6921: FROM qrm_current_deals_v
6922: WHERE deal_no=p_deal_no
6923: GROUP BY settle_date ;
6924:
6925:

Line 7058: FROM qrm_current_deals_v

7054: SELECT deal_calc_id, deal_no, transaction_no
7055: FROM qrm_deal_calculations
7056: WHERE (deal_no, transaction_no) IN
7057: (SELECT deal_no, transaction_no
7058: FROM qrm_current_deals_v
7059: WHERE nvl(end_date, p_ref_date+1) < p_ref_date);
7060:
7061: -- get calculated deals are no longer open
7062: /* CURSOR get_old_deal_ids IS

Line 7067: FROM qrm_current_deals_v); Bug 4965436 */

7063: SELECT deal_calc_id, deal_no, transaction_no
7064: FROM qrm_deal_calculations
7065: WHERE (deal_no, transaction_no) NOT IN
7066: (SELECT deal_no, transaction_no
7067: FROM qrm_current_deals_v); Bug 4965436 */
7068:
7069: -- get calculated deals are no longer open
7070: CURSOR get_old_deal_ids IS
7071: SELECT deal_calc_id, deal_no, transaction_no

Line 7074: from qrm_current_deals_v qcdv

7070: CURSOR get_old_deal_ids IS
7071: SELECT deal_calc_id, deal_no, transaction_no
7072: FROM qrm_deal_calculations qdc
7073: WHERE NOT EXISTS ( select 'x'
7074: from qrm_current_deals_v qcdv
7075: where qcdv.deal_no = qdc.deal_no
7076: and qcdv.transaction_no = qdc.transaction_no ) ;
7077:
7078: