APPS.XTR_REVAL_PROCESS_P dependencies on XTR_IG_ELIGIBLE_DEALS_V

Line 525: Select distinct deal_no, currencya from XTR_IG_ELIGIBLE_DEALS_V

521:
522: -- For IG, we calculate currency G/L for each deal number of the company
523: -- which is the unique combination of company, cparty, and currency
524: Cursor c_ig_deal is
525: Select distinct deal_no, currencya from XTR_IG_ELIGIBLE_DEALS_V
526: where eligible_date <= l_batch_end and company_code = l_company_code;
527:
528: Cursor c_iro_deal is
529: Select * from XTR_IRO_ELIGIBLE_DEALS_V

Line 1185: from xtr_ig_eligible_deals_v

1181: xtr_revl_ig_curr_gl(rec, l_rc);
1182: if l_rc = 1 then -- deal is incomplete
1183: select face_value, product_type
1184: into rec.face_value, rec.product_type
1185: from xtr_ig_eligible_deals_v
1186: where deal_no = rec.deal_no
1187: and company_code = rec.company_code
1188: and transaction_no = (select max(transaction_no)
1189: from xtr_ig_eligible_deals_v

Line 1189: from xtr_ig_eligible_deals_v

1185: from xtr_ig_eligible_deals_v
1186: where deal_no = rec.deal_no
1187: and company_code = rec.company_code
1188: and transaction_no = (select max(transaction_no)
1189: from xtr_ig_eligible_deals_v
1190: where deal_no = rec.deal_no
1191: and effective_date = (select max(effective_date)
1192: from xtr_ig_eligible_deals_v
1193: where deal_no = rec.deal_no

Line 1192: from xtr_ig_eligible_deals_v

1188: and transaction_no = (select max(transaction_no)
1189: from xtr_ig_eligible_deals_v
1190: where deal_no = rec.deal_no
1191: and effective_date = (select max(effective_date)
1192: from xtr_ig_eligible_deals_v
1193: where deal_no = rec.deal_no
1194: and company_code = rec.company_code
1195: and eligible_date <= rec.revldate));
1196: rec.fair_value := rec.face_value;