APPS.XTR_FPS2_P dependencies on XTR_DEDUCTION_CALCS_V

Line 880: XTR_DEDUCTION_CALCS_V d

876: select b.BROKERAGE_REFERENCE, d.AMOUNT_TYPE
877: from XTR_PARTY_DEFAULTS b,
878: XTR_PARTIES_V p,
879: XTR_TAX_BROKERAGE_SETUP a,
880: XTR_DEDUCTION_CALCS_V d
881: where p.PARTY_CODE = l_ref_party
882: and b.BROKERAGE_CATEGORY = p.BROKERAGE_CATEGORY
883: and b.DEFAULT_TYPE = 'B'
884: and b.DEAL_TYPE = l_deal_type

Line 901: XTR_DEDUCTION_CALCS_V d

897: select b.TAX_REFERENCE, d.AMOUNT_TYPE
898: from XTR_PARTY_DEFAULTS b,
899: XTR_PARTIES_V p,
900: XTR_TAX_BROKERAGE_SETUP a,
901: XTR_DEDUCTION_CALCS_V d
902: where p.PARTY_CODE = l_ref_party
903: and b.TAX_CATEGORY = p.TAX_CATEGORY
904: and b.DEFAULT_TYPE = 'T'
905: and b.DEAL_TYPE = l_deal_type

Line 1008: XTR_DEDUCTION_CALCS_V d

1004: select b.BROKERAGE_REFERENCE, d.AMOUNT_TYPE
1005: from XTR_PARTY_DEFAULTS b,
1006: XTR_PARTIES_V p,
1007: XTR_TAX_BROKERAGE_SETUP a,
1008: XTR_DEDUCTION_CALCS_V d
1009: where p.PARTY_CODE = l_ref_party
1010: and b.BROKERAGE_CATEGORY = p.BROKERAGE_CATEGORY
1011: and b.DEFAULT_TYPE = 'B'
1012: and b.DEAL_TYPE = l_deal_type

Line 1082: XTR_DEDUCTION_CALCS_V d

1078: --
1079: cursor BKR_AMT_TYPE is
1080: select d.AMOUNT_TYPE
1081: from XTR_TAX_BROKERAGE_SETUP a,
1082: XTR_DEDUCTION_CALCS_V d
1083: where a.DEAL_TYPE = l_deal_type
1084: and a.REFERENCE_CODE = l_bkr_ref
1085: and nvl(a.AUTHORISED,'N')= 'Y'
1086: and d.DEAL_TYPE = a.DEAL_TYPE

Line 1092: XTR_DEDUCTION_CALCS_V d

1088: --
1089: cursor TAX_AMT_TYPE is
1090: select d.AMOUNT_TYPE
1091: from XTR_TAX_BROKERAGE_SETUP a,
1092: XTR_DEDUCTION_CALCS_V d
1093: where a.DEAL_TYPE = l_deal_type
1094: and a.REFERENCE_CODE = l_tax_ref
1095: and nvl(a.AUTHORISED,'N')= 'Y'
1096: and d.DEAL_TYPE = a.DEAL_TYPE