DBA Data[Home] [Help]

APPS.XTR_FPS1_P dependencies on XTR_DEDUCTION_CALCS

Line 346: XTR_DEDUCTION_CALCS b,

342: cursor BKGE_DETAILS is
343: select b.CALC_BASIS,
344: nvl(d.INTEREST_RATE,0)
345: from XTR_TAX_BROKERAGE_SETUP a,
346: XTR_DEDUCTION_CALCS b,
347: XTR_TAX_BROKERAGE_RATES d
348: where a.REFERENCE_CODE = l_bkge_ref
349: and nvl(a.AUTHORISED,'N') = 'Y'
350: and b.DEAL_TYPE = l_deal_type

Line 364: XTR_DEDUCTION_CALCS b,

360: cursor TAX_DETAILS is
361: select b.CALC_BASIS,
362: nvl(d.INTEREST_RATE,0)
363: from XTR_TAX_BROKERAGE_SETUP a,
364: XTR_DEDUCTION_CALCS b,
365: XTR_TAX_BROKERAGE_RATES d
366: where a.REFERENCE_CODE = l_tax_ref
367: and nvl(a.AUTHORISED,'N') = 'Y'
368: and b.DEAL_TYPE = l_deal_type