APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 2668: insert into XTR_ROLLOVER_TRANSACTIONS_V

2664: for i in 1..g_num_parcels loop
2665: for j in 1..G_Ni_Parcel_Rec(i).PARCEL_SIZE loop
2666: l_tran_no := l_tran_no + 1;
2667:
2668: insert into XTR_ROLLOVER_TRANSACTIONS_V
2669: (DEAL_NUMBER,DEAL_DATE,TRANSACTION_NUMBER,DEAL_TYPE,DEAL_SUBTYPE,
2670: BALANCE_OUT,CURRENCY,PARCEL_SPLIT_NO,CREATED_BY,CREATED_ON,
2671: INTEREST_RATE,START_DATE,MATURITY_DATE,NO_OF_DAYS,COMPANY_CODE,
2672: STATUS_CODE,PRODUCT_TYPE,CLIENT_CODE,INTEREST,ENDORSER_CODE,

Line 2781: update XTR_ROLLOVER_TRANSACTIONS_V

2777: end if;
2778: --------------------------------
2779: -- Update RT brokerage amount --
2780: --------------------------------
2781: update XTR_ROLLOVER_TRANSACTIONS_V
2782: set BROKERAGE_AMOUNT = round(decode(l_total_parcel,
2783: 1,G_Ni_Main_Rec.BROKERAGE_AMOUNT- l_running_bkge_amt,
2784: (G_Ni_Main_Rec.BROKERAGE_AMOUNT/l_total_face_value)*balance_out),
2785: l_rounding),