APPS.XTR_REVAL_PROCESS_P dependencies on XTR_BOND_ALLOC_DETAILS

Line 7596: from XTR_BOND_ALLOC_DETAILS BOND,

7592: Select bond.deal_no, bond.cross_ref_no, bond.face_value, bond.initial_fair_value,
7593: bond.amc_real_gain_loss, bond.mtm_real_gain_loss, bond.cross_ref_clean_px,
7594: decode(cp.parameter_value_code, 'TRADE', bond.cross_ref_deal_date,
7595: bond.cross_ref_start_date) resale_rec_date
7596: from XTR_BOND_ALLOC_DETAILS BOND,
7597: XTR_COMPANY_PARAMETERS CP,
7598: XTR_DEALS D
7599: Where bond.deal_no = rec.deal_no
7600: and bond.deal_no = d.deal_no

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

7652: XTR_REVL_BOND_REALAMC(rec, bo_rec);
7653: XTR_REVL_BOND_REALMTM(rec, bo_rec, l_resale);
7654: XTR_REVL_BOND_UNREAL(rec, bo_rec, l_resale, l_overwrite);
7655:
7656: -- Update xtr_bond_alloc_details record so this record will not be
7657: -- eligible for next time
7658: Update XTR_BOND_ALLOC_DETAILS
7659: Set batch_id = rec.batch_id
7660: where deal_no = bo_rec.deal_no

Line 7658: Update XTR_BOND_ALLOC_DETAILS

7654: XTR_REVL_BOND_UNREAL(rec, bo_rec, l_resale, l_overwrite);
7655:
7656: -- Update xtr_bond_alloc_details record so this record will not be
7657: -- eligible for next time
7658: Update XTR_BOND_ALLOC_DETAILS
7659: Set batch_id = rec.batch_id
7660: where deal_no = bo_rec.deal_no
7661: and cross_ref_no = bo_rec.cross_ref_no;
7662:

Line 7860: from xtr_bond_alloc_details

7856: l_begin_fv := l_full_init_fv; -- 3046471.
7857: else
7858: select sum(initial_fair_value) -- 2879585. Correction from initial design.
7859: into l_bond_init_fv
7860: from xtr_bond_alloc_details
7861: where deal_no = rec.deal_no;
7862: --3046471 l_begin_fv := rec.init_fv - l_bond_init_fv;
7863: l_begin_fv := l_full_init_fv - l_bond_init_fv; -- 3046471.
7864: end if;

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

8704: l_resale := TRUE;
8705: XTR_REVL_STOCK_REAL(rec, st_rec);
8706: XTR_REVL_STOCK_UNREAL(rec, st_rec, l_resale, l_overwrite, l_dummy, l_dummy1, l_dummy2);
8707:
8708: -- Update xtr_bond_alloc_details record so this record will not be
8709: -- eligible for next time
8710: Update XTR_STOCK_ALLOC_DETAILS
8711: Set batch_id = rec.batch_id
8712: where deal_no = st_rec.deal_no