APPS.XTR_FPS1_P dependencies on XTR_TAX_BROKERAGE_SETUP

Line 345: from XTR_TAX_BROKERAGE_SETUP a,

341: --
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'

Line 363: from XTR_TAX_BROKERAGE_SETUP a,

359: --
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'

Line 547: from XTR_TAX_BROKERAGE_SETUP a,

543: l_rounding_precision VARCHAR2(20);
544:
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'

Line 562: from XTR_TAX_BROKERAGE_SETUP

558:
559:
560: cursor GET_ROUNDING_RULES(l_ref VARCHAR2) is
561: select tax_rounding_rule, tax_rounding_precision
562: from XTR_TAX_BROKERAGE_SETUP
563: where reference_code = l_ref;
564:
565: begin
566: -- inititate out variables

Line 647: FROM XTR_TAX_BROKERAGE_SETUP

643: l_settle_method VARCHAR2(15);
644:
645: CURSOR get_settle_method IS
646: SELECT tax_settle_method
647: FROM XTR_TAX_BROKERAGE_SETUP
648: WHERE reference_code = l_tax_ref;
649: BEGIN
650: OPEN get_settle_method;
651: FETCH get_settle_method INTO l_settle_method;