APPS.XTR_REVAL_PROCESS_P dependencies on XTR_HEDGE_RELATIONSHIPS

Line 504: from xtr_hedge_relationships H, xtr_revaluation_details R

500: Cursor c_fx_hedge_deal is
501: Select * from XTR_FX_ELIGIBLE_DEALS_V
502: where eligible_date <= l_batch_end and company_code = l_company_code
503: and deal_no in (select h.primary_code
504: from xtr_hedge_relationships H, xtr_revaluation_details R
505: where h.instrument_item_flag = 'U'
506: and r.batch_id = p_batch_id
507: and h.hedge_attribute_id = r.deal_no);
508:

Line 513: from xtr_hedge_relationships H, xtr_revaluation_details R

509: Cursor c_fx_deal is
510: Select * from XTR_FX_ELIGIBLE_DEALS_V
511: where eligible_date <= l_batch_end and company_code = l_company_code
512: and deal_no not in (select h.primary_code
513: from xtr_hedge_relationships H, xtr_revaluation_details R
514: where h.instrument_item_flag = 'U'
515: and r.batch_id = p_batch_id
516: and h.hedge_attribute_id = r.deal_no);
517:

Line 1325: from xtr_hedge_relationships

1321: r_rd OUT NOCOPY XTR_REVALUATION_DETAILS%rowtype) is
1322:
1323: Cursor C_ITEM_TOTAL is
1324: select sum(reference_amount)
1325: from xtr_hedge_relationships
1326: where hedge_attribute_id = rec.deal_no
1327: and instrument_item_flag = 'I';
1328:
1329: Cursor C_HEDGE_BAL is

Line 6052: XTR_HEDGE_RELATIONSHIPS r

6048: /******************************************************/
6049: cursor C_REVAL_DATE(p_last_end_date DATE) is
6050: select a.start_date reval_date
6051: from XTR_HEDGE_ATTRIBUTES a,
6052: XTR_HEDGE_RELATIONSHIPS r
6053: where a.hedge_attribute_id = r.hedge_attribute_id
6054: and r.primary_code = rec.deal_no
6055: and r.instrument_item_flag = 'U'
6056: and a.start_date < rec.revldate

Line 6061: XTR_HEDGE_RELATIONSHIPS r

6057: and a.start_date >= p_last_end_date
6058: union
6059: select nvl(discontinue_date, end_date) reval_date
6060: from XTR_HEDGE_ATTRIBUTES a,
6061: XTR_HEDGE_RELATIONSHIPS r
6062: where a.hedge_attribute_id = r.hedge_attribute_id
6063: and r.primary_code = rec.deal_no
6064: and r.instrument_item_flag = 'U'
6065: and nvl(a.discontinue_date, a.end_date) < rec.revldate

Line 6069: from XTR_RECLASS_DETAILS c, xtr_hedge_relationships R

6065: and nvl(a.discontinue_date, a.end_date) < rec.revldate
6066: and nvl(a.discontinue_date, a.end_date) >= p_last_end_date
6067: union
6068: select c.reclass_date reval_date
6069: from XTR_RECLASS_DETAILS c, xtr_hedge_relationships R
6070: where c.hedge_attribute_id = r.hedge_attribute_id
6071: and r.primary_code = rec.deal_no
6072: and r.instrument_item_flag = 'U'
6073: and c.reclass_date > p_last_end_date -- bug 4214523