eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_FPS2_P dependencies on XTR_TAX_BROKERAGE_SETUP

Line 879: XTR_TAX_BROKERAGE_SETUP a,

875: --select b.BROKERAGE_REFERENCE,nvl(d.INTEREST_RATE,0),d.FLAT_AMOUNT
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'

Line 900: XTR_TAX_BROKERAGE_SETUP a,

896: --select b.TAX_REFERENCE, d.INTEREST_RATE
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'

Line 1007: XTR_TAX_BROKERAGE_SETUP a,

1003: --select b.BROKERAGE_REFERENCE,nvl(d.INTEREST_RATE,0),d.FLAT_AMOUNT
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'

Line 1028: XTR_TAX_BROKERAGE_SETUP a,

1024: --select b.TAX_REFERENCE, d.INTEREST_RATE
1025: select b.TAX_REFERENCE, b.INCOME_TAX_REFERENCE, d.CALC_TYPE
1026: from XTR_PARTY_DEFAULTS b,
1027: XTR_PARTIES_V p,
1028: XTR_TAX_BROKERAGE_SETUP a,
1029: XTR_TAX_DEDUCTION_CALCS_V d
1030: where p.PARTY_CODE = l_ref_party
1031: and b.TAX_CATEGORY = p.TAX_CATEGORY
1032: and b.DEFAULT_TYPE = 'T'

Line 1081: from XTR_TAX_BROKERAGE_SETUP a,

1077: l_tax_amt_type IN OUT NOCOPY VARCHAR2) is
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'

Line 1091: from XTR_TAX_BROKERAGE_SETUP a,

1087: and d.CALC_TYPE = a.CALC_TYPE;
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'

Line 1122: v_cparty Xtr_Tax_Brokerage_Setup_V.Payee%Type;

1118: v_validation_error Boolean;
1119: v_limit_error Boolean;
1120:
1121: v_exp_rec Xtr_Exposure_Transactions%Rowtype;
1122: v_cparty Xtr_Tax_Brokerage_Setup_V.Payee%Type;
1123: v_settlement_code Xtr_One_Step_Settle_Codes.Settlement_Code%Type;
1124: v_amount_hce Xtr_Exposure_Transactions.Amount_HCE%Type;
1125: v_comments Xtr_Exposure_Transactions.Comments%Type;
1126: v_settle_method Xtr_Tax_Brokerage_Setup.Tax_Settle_Method%Type;

Line 1126: v_settle_method Xtr_Tax_Brokerage_Setup.Tax_Settle_Method%Type;

1122: v_cparty Xtr_Tax_Brokerage_Setup_V.Payee%Type;
1123: v_settlement_code Xtr_One_Step_Settle_Codes.Settlement_Code%Type;
1124: v_amount_hce Xtr_Exposure_Transactions.Amount_HCE%Type;
1125: v_comments Xtr_Exposure_Transactions.Comments%Type;
1126: v_settle_method Xtr_Tax_Brokerage_Setup.Tax_Settle_Method%Type;
1127: v_party_type Xtr_Parties_V.Party_Type%Type;
1128:
1129: cursor CALC_HCE_AMTS is
1130: select round(abs(p_one_step_rec.p_amount) / s.HCE_RATE,2)

Line 1140: From Xtr_Tax_Brokerage_Setup_V

1136:
1137: Begin
1138: Select tax_settle_method
1139: Into v_settle_method
1140: From Xtr_Tax_Brokerage_Setup_V
1141: Where reference_code = p_one_step_rec.p_schedule_code;
1142: Exception
1143: When no_data_found then
1144: null;

Line 1881: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;

1877:
1878: v_RT Xtr_Rollover_Transactions_V%Rowtype;
1879: v_first_time Char(1) := 'Y';
1880: v_last_trans Varchar2(1) ;
1881: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1882: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
1883: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1884: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
1885:

Line 1882: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;

1878: v_RT Xtr_Rollover_Transactions_V%Rowtype;
1879: v_first_time Char(1) := 'Y';
1880: v_last_trans Varchar2(1) ;
1881: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1882: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
1883: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1884: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
1885:
1886: Begin

Line 1883: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;

1879: v_first_time Char(1) := 'Y';
1880: v_last_trans Varchar2(1) ;
1881: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1882: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
1883: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1884: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
1885:
1886: Begin
1887:

Line 1884: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;

1880: v_last_trans Varchar2(1) ;
1881: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1882: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
1883: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1884: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
1885:
1886: Begin
1887:
1888: If p_deal_type = 'TMM' then

Line 2181: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;

2177:
2178: v_RT Xtr_Rollover_Transactions_V%Rowtype;
2179: v_first_time Char(1) := 'Y';
2180: v_last_trans Varchar2(1) ;
2181: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2182: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
2183: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2184: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
2185:

Line 2182: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;

2178: v_RT Xtr_Rollover_Transactions_V%Rowtype;
2179: v_first_time Char(1) := 'Y';
2180: v_last_trans Varchar2(1) ;
2181: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2182: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
2183: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2184: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
2185:
2186: Begin

Line 2183: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;

2179: v_first_time Char(1) := 'Y';
2180: v_last_trans Varchar2(1) ;
2181: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2182: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
2183: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2184: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
2185:
2186: Begin
2187: If p_deal_type = 'TMM' then

Line 2184: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;

2180: v_last_trans Varchar2(1) ;
2181: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2182: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
2183: v_income_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2184: v_income_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;
2185:
2186: Begin
2187: If p_deal_type = 'TMM' then
2188: -- Invalid deals

Line 2499: FROM XTR_TAX_BROKERAGE_SETUP

2495:
2496: CURSOR settle_method (l_tax_code VARCHAR2) IS
2497: SELECT calc_type,
2498: tax_settle_method
2499: FROM XTR_TAX_BROKERAGE_SETUP
2500: WHERE reference_code = l_tax_code;
2501:
2502: BEGIN
2503: