APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_HEDGE_ATTRIBUTES

Line 73: from xtr_hedge_strategies s, xtr_hedge_attributes h

69: l_hd_excl_prv_cum NUMBER;
70:
71: cursor hdg is
72: select s.hedge_approach, h.hedge_amount, h.exclusion_item_code
73: from xtr_hedge_strategies s, xtr_hedge_attributes h
74: where s.strategy_code = h.strategy_code
75: and h.hedge_attribute_id = p_hedge_no;
76:
77: cursor ref_amt is

Line 386: from xtr_hedge_attributes ha, xtr_hedge_strategies hs

382: nvl(sum(reclass_gain_loss_amt),0) reclass_gain_loss_amt
383: from xtr_deal_retro_tests d
384: where d.batch_id = p_batch_id
385: and d.hedge_attribute_id in (select hedge_attribute_id
386: from xtr_hedge_attributes ha, xtr_hedge_strategies hs
387: where ha.strategy_code = hs.strategy_code
388: and hs.hedge_type = 'CASHFLOW')
389: group by deal_number, amount_type, result_date
390: order by deal_number, amount_type, result_date;

Line 978: from xtr_reclass_details r, xtr_hedge_attributes h, xtr_hedge_strategies s

974: ,NULL unrealised_pl
975: ,NULL realised_pl
976: ,NULL curr_gain_loss_amount
977: ,NULL realized_flag
978: from xtr_reclass_details r, xtr_hedge_attributes h, xtr_hedge_strategies s
979: where r.hedge_attribute_id = h.hedge_attribute_id
980: and h.strategy_code = s.strategy_code
981: and h.company_code = p_company
982: and r.reclass_date <= p_cb_end_date

Line 1119: from xtr_hedge_attributes

1115: get test related data for this hedge
1116: --------------------------------------------------------*/
1117: cursor hedge(p_hedge_no in number) is
1118: select retro_method, retro_tolerance_min,retro_tolerance_max,exclusion_item_code
1119: from xtr_hedge_attributes
1120: where hedge_attribute_id = p_hedge_no;
1121:
1122: cursor retro(p_hedge_no in number) is
1123: select pct_effective

Line 1742: l_status XTR_HEDGE_ATTRIBUTES.HEDGE_STATUS%TYPE;

1738: where organization_id = l_ap_org_id;
1739:
1740: -- AP Related Variables and cursors End
1741:
1742: l_status XTR_HEDGE_ATTRIBUTES.HEDGE_STATUS%TYPE;
1743:
1744: cursor hedge(hedge_no in number) is
1745: select hedge_status
1746: from xtr_hedge_attributes

Line 1746: from xtr_hedge_attributes

1742: l_status XTR_HEDGE_ATTRIBUTES.HEDGE_STATUS%TYPE;
1743:
1744: cursor hedge(hedge_no in number) is
1745: select hedge_status
1746: from xtr_hedge_attributes
1747: where hedge_attribute_id = hedge_no;
1748:
1749: l_count NUMBER := 0;
1750:

Line 1990: xtr_hedge_relationships hr, xtr_hedge_attributes ha

1986: LAST_UPDATE_LOGIN X_LAST_UPDATE_LOGIN;
1987:
1988: cursor pct(p_prim_code in VARCHAR2, p_sec_code in VARCHAR2) is
1989: select nvl(sum(pct_allocation),0) from
1990: xtr_hedge_relationships hr, xtr_hedge_attributes ha
1991: where hr.hedge_attribute_id = ha.hedge_attribute_id
1992: and ((ha.hedge_status in ('DESIGNATE','CURRENT','FULFILLED'))
1993: OR (hedge_status in ('FAILED','DEDESIGNATED') and ha.start_date <= ha.discontinue_date)
1994: )

Line 2355: from xtr_hedge_attributes

2351:
2352:
2353: cursor hedge_dtls(hedge_no in NUMBER) is
2354: select company_code, hedge_currency
2355: from xtr_hedge_attributes
2356: where hedge_attribute_id = hedge_no;
2357:
2358: l_company XTR_PARTY_INFO.PARTY_CODE%TYPE;
2359: l_currency XTR_MASTER_CURRENCIES.CURRENCY%TYPE;