APPS.XTR_REVAL_PROCESS_P dependencies on XTR_FX_ELIGIBLE_DEALS_V

Line 501: Select * from XTR_FX_ELIGIBLE_DEALS_V

497: Select * from XTR_ELIGIBLE_HEDGES_V
498: where eligible_date <= l_batch_end and company_code = l_company_code;
499:
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'

Line 510: Select * from XTR_FX_ELIGIBLE_DEALS_V

506: and r.batch_id = p_batch_id
507: and h.hedge_attribute_id = r.deal_no);
508:
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'

Line 6077: from xtr_fx_eligible_deals_v

6073: and c.reclass_date > p_last_end_date -- bug 4214523
6074: and c.reclass_date < rec.revldate
6075: union
6076: select effective_date reval_date
6077: from xtr_fx_eligible_deals_v
6078: where deal_no = rec.deal_no
6079: and effective_date < rec.revldate
6080: union
6081: select period_end reval_date