DBA Data[Home] [Help]

APPS.XTR_FPS1_P dependencies on XTR_TAX_BROKERAGE_RATES

Line 347: XTR_TAX_BROKERAGE_RATES d

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
351: and b.CALC_TYPE = a.CALC_TYPE

Line 365: XTR_TAX_BROKERAGE_RATES d

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
369: and b.CALC_TYPE = a.CALC_TYPE

Line 549: XTR_TAX_BROKERAGE_RATES d

545: cursor TAX_DETAILS (l_tax_ref VARCHAR2) is
546: select b.CALC_BASIS, b.CALC_TYPE, nvl(d.INTEREST_RATE,0)
547: from XTR_TAX_BROKERAGE_SETUP a,
548: XTR_TAX_DEDUCTION_CALCS b,
549: XTR_TAX_BROKERAGE_RATES d
550: where a.REFERENCE_CODE = l_tax_ref
551: and nvl(a.AUTHORISED,'N') = 'Y'
552: and b.DEAL_TYPE = l_deal_type
553: and b.CALC_TYPE = a.CALC_TYPE