APPS.XTR_REVAL_PROCESS_P dependencies on XTR_CA_ELIGIBLE_DEALS_V

Line 567: from XTR_CA_ELIGIBLE_DEALS_V CA,

563: -- For CA, we calculate currency G/L for each account number of the company
564: Cursor c_ca_acct is
565: Select distinct ca.account_no, ca.currencya, dda.deal_number,
566: ca.portfolio_code
567: from XTR_CA_ELIGIBLE_DEALS_V CA,
568: XTR_DEAL_DATE_AMOUNTS DDA
569: where ca.company_code = l_company_code
570: and ca.eligible_date <= l_batch_end
571: and ca.company_code = dda.company_code

Line 1235: from xtr_ca_eligible_deals_v

1231: xtr_revl_ca_curr_gl(rec, l_rc);
1232: if l_rc = 1 then -- deal is incomplete
1233: select nvl(face_value,0), transaction_rate -- added nvl for R12
1234: into rec.face_value, rec.transaction_rate
1235: from xtr_ca_eligible_deals_v
1236: where account_no = rec.account_no
1237: and company_code = rec.company_code
1238: and effective_date = (select max(effective_date)
1239: from xtr_ca_eligible_deals_v

Line 1239: from xtr_ca_eligible_deals_v

1235: from xtr_ca_eligible_deals_v
1236: where account_no = rec.account_no
1237: and company_code = rec.company_code
1238: and effective_date = (select max(effective_date)
1239: from xtr_ca_eligible_deals_v
1240: where account_no = rec.account_no
1241: and company_code = rec.company_code
1242: and eligible_date <= rec.revldate);
1243: rec.fair_value := rec.face_value;

Line 2912: from XTR_CA_ELIGIBLE_DEALS_V

2908: Where company_code = rec.company_code
2909: and account_number = rec.account_no
2910: and balance_date =
2911: (select max(effective_date)
2912: from XTR_CA_ELIGIBLE_DEALS_V
2913: where company_code = rec.company_code
2914: and account_no = rec.account_no
2915: and effective_date <= rec.revldate)
2916: and last_batch_id is null;