APPS.XTR_REVAL_PROCESS_P dependencies on XTR_BOND_ALLOC_DETAILS

Line 7615: from XTR_BOND_ALLOC_DETAILS BOND,

7611: Select bond.deal_no, bond.cross_ref_no, bond.face_value, bond.initial_fair_value,
7612: bond.amc_real_gain_loss, bond.mtm_real_gain_loss, bond.cross_ref_clean_px,
7613: decode(cp.parameter_value_code, 'TRADE', bond.cross_ref_deal_date,
7614: bond.cross_ref_start_date) resale_rec_date
7615: from XTR_BOND_ALLOC_DETAILS BOND,
7616: XTR_COMPANY_PARAMETERS CP,
7617: XTR_DEALS D
7618: Where bond.deal_no = rec.deal_no
7619: and bond.deal_no = d.deal_no

Line 7675: -- Update xtr_bond_alloc_details record so this record will not be

7671: XTR_REVL_BOND_REALAMC(rec, bo_rec);
7672: XTR_REVL_BOND_REALMTM(rec, bo_rec, l_resale);
7673: XTR_REVL_BOND_UNREAL(rec, bo_rec, l_resale, l_overwrite);
7674:
7675: -- Update xtr_bond_alloc_details record so this record will not be
7676: -- eligible for next time
7677: Update XTR_BOND_ALLOC_DETAILS
7678: Set batch_id = rec.batch_id
7679: where deal_no = bo_rec.deal_no

Line 7677: Update XTR_BOND_ALLOC_DETAILS

7673: XTR_REVL_BOND_UNREAL(rec, bo_rec, l_resale, l_overwrite);
7674:
7675: -- Update xtr_bond_alloc_details record so this record will not be
7676: -- eligible for next time
7677: Update XTR_BOND_ALLOC_DETAILS
7678: Set batch_id = rec.batch_id
7679: where deal_no = bo_rec.deal_no
7680: and cross_ref_no = bo_rec.cross_ref_no;
7681:

Line 7879: from xtr_bond_alloc_details

7875: l_begin_fv := l_full_init_fv; -- 3046471.
7876: else
7877: select sum(initial_fair_value) -- 2879585. Correction from initial design.
7878: into l_bond_init_fv
7879: from xtr_bond_alloc_details
7880: where deal_no = rec.deal_no;
7881: --3046471 l_begin_fv := rec.init_fv - l_bond_init_fv;
7882: l_begin_fv := l_full_init_fv - l_bond_init_fv; -- 3046471.
7883: end if;

Line 8727: -- Update xtr_bond_alloc_details record so this record will not be

8723: l_resale := TRUE;
8724: XTR_REVL_STOCK_REAL(rec, st_rec);
8725: XTR_REVL_STOCK_UNREAL(rec, st_rec, l_resale, l_overwrite, l_dummy, l_dummy1, l_dummy2);
8726:
8727: -- Update xtr_bond_alloc_details record so this record will not be
8728: -- eligible for next time
8729: Update XTR_STOCK_ALLOC_DETAILS
8730: Set batch_id = rec.batch_id
8731: where deal_no = st_rec.deal_no