APPS.XTR_FPS2_P dependencies on XTR_DEAL_DATE_AMOUNTS_V

Line 192: from XTR_DEAL_DATE_AMOUNTS_V

188: l_dealer IN VARCHAR2,
189: l_exists IN OUT NOCOPY VARCHAR2) as
190: cursor DEAL_EXISTS_YN is
191: select 'Y'
192: from XTR_DEAL_DATE_AMOUNTS_V
193: where AMOUNT_DATE = l_date
194: and COMPANY_CODE like nvl(l_company,'%')
195: and DEAL_TYPE like nvl(l_d_type,'%')
196: and DEAL_SUBTYPE like nvl(l_d_subty,'%')

Line 3020: delete from XTR_DEAL_DATE_AMOUNTS_V

3016: if p_tax_settle_no is not null then
3017: delete from XTR_EXPOSURE_TRANSACTIONS
3018: where TRANSACTION_NUMBER = p_tax_settle_no;
3019:
3020: delete from XTR_DEAL_DATE_AMOUNTS_V
3021: where DEAL_TYPE = 'EXP'
3022: and deal_number = 0
3023: and TRANSACTION_NUMBER = p_tax_settle_no;
3024:

Line 3057: from xtr_deal_date_amounts_v

3053: PROCEDURE UPDATE_TAX_DDA (p_exp_number NUMBER,
3054: p_amount NUMBER) IS
3055: cursor get_dda_cashflow is
3056: select cashflow_amount
3057: from xtr_deal_date_amounts_v
3058: where transaction_number=p_exp_number
3059: and deal_type='EXP'
3060: and deal_number=0;
3061: v_cashflow NUMBER;

Line 3069: update xtr_deal_date_amounts_v

3065: close get_dda_cashflow;
3066: if v_cashflow=0 then
3067: --need to update with ADDition since the DDA cashflow_amount for TAX
3068: --is always negative
3069: update xtr_deal_date_amounts_v
3070: set amount=amount-nvl(p_amount,0)
3071: where transaction_number=p_exp_number
3072: and deal_type='EXP'
3073: and deal_number=0;

Line 3075: update xtr_deal_date_amounts_v

3071: where transaction_number=p_exp_number
3072: and deal_type='EXP'
3073: and deal_number=0;
3074: else
3075: update xtr_deal_date_amounts_v
3076: set amount=amount-nvl(p_amount,0),
3077: cashflow_amount=cashflow_amount+nvl(p_amount,0)
3078: where transaction_number=p_exp_number
3079: and deal_type='EXP'