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_PARTIES_V

Line 216: from XTR_PARTIES_V a,

212: --
213: /* Modified below cursors Bug 4647357
214: cursor COMP_DFLT is
215: select a.PARTY_CODE, a.SHORT_NAME, d.CURRENCY_CODE, b.NAME
216: from XTR_PARTIES_V a,
217: XTR_MASTER_CURRENCIES b,
218: HR_LEGAL_ENTITIES c,
219: GL_SETS_OF_BOOKS d
220: where a.PARTY_TYPE = 'C'

Line 228: from XTR_PARTIES_V a,

224: and b.CURRENCY = d.CURRENCY_CODE;
225: --
226: cursor COMP_CCY is
227: select d.CURRENCY_CODE, b.NAME
228: from XTR_PARTIES_V a,
229: XTR_MASTER_CURRENCIES b,
230: HR_LEGAL_ENTITIES c,
231: GL_SETS_OF_BOOKS d
232: where a.PARTY_TYPE = 'C'

Line 240: from XTR_PARTIES_V a,

236: and b.CURRENCY = d.CURRENCY_CODE;
237: */
238: cursor COMP_DFLT is
239: select a.PARTY_CODE, a.SHORT_NAME, d.CURRENCY_CODE, b.NAME
240: from XTR_PARTIES_V a,
241: XTR_MASTER_CURRENCIES b,
242: GL_LEDGER_LE_V c,
243: GL_SETS_OF_BOOKS d
244: where a.PARTY_TYPE = 'C'

Line 253: from XTR_PARTIES_V a,

249: and b.CURRENCY = d.CURRENCY_CODE;
250: --
251: cursor COMP_CCY is
252: select d.CURRENCY_CODE, b.NAME
253: from XTR_PARTIES_V a,
254: XTR_MASTER_CURRENCIES b,
255: GL_LEDGER_LE_V c,
256: GL_SETS_OF_BOOKS d
257: where a.PARTY_TYPE = 'C'

Line 294: from XTR_PARTIES_V a,

290: l_ccy IN OUT NOCOPY VARCHAR2,
291: l_ccy_name IN OUT NOCOPY VARCHAR2) is
292: cursor DFLT is
293: select a.HOME_CURRENCY,b.NAME
294: from XTR_PARTIES_V a,
295: XTR_MASTER_CURRENCIES b
296: where a.PARTY_CODE = l_pty
297: and b.CURRENCY = a.HOME_CURRENCY;
298: --

Line 725: from XTR_PARTIES_V

721: l_company_name IN OUT NOCOPY VARCHAR2) is
722: --
723: cursor PTY_CODE is
724: select PARTY_CODE, SHORT_NAME
725: from XTR_PARTIES_V
726: where PARTY_TYPE = 'C'
727: and DEFAULT_COMPANY = 'Y';
728: --
729: begin

Line 864: XTR_PARTIES_V p

860: select pd.PRINCIPAL_SETTLED_BY,
861: pd.INTEREST_SETTLED_BY,
862: pd.FREQ_INTEREST_SETTLED
863: from XTR_PARTY_DEFAULTS pd,
864: XTR_PARTIES_V p
865: where p.PARTY_CODE = l_ref_party
866: and pd.SETTLEMENT_DEFAULT_CATEGORY = p.SETTLEMENT_DEFAULT_CATEGORY
867: and pd.DEFAULT_TYPE = 'S'
868: and pd.DEAL_TYPE = l_deal_type

Line 878: XTR_PARTIES_V p,

874: cursor BROKER_DFLTS is
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

Line 899: XTR_PARTIES_V p,

895: cursor TAX_DFLTS is
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

Line 992: XTR_PARTIES_V p

988: select pd.PRINCIPAL_SETTLED_BY,
989: pd.INTEREST_SETTLED_BY,
990: pd.FREQ_INTEREST_SETTLED
991: from XTR_PARTY_DEFAULTS pd,
992: XTR_PARTIES_V p
993: where p.PARTY_CODE = l_ref_party
994: and pd.SETTLEMENT_DEFAULT_CATEGORY = p.SETTLEMENT_DEFAULT_CATEGORY
995: and pd.DEFAULT_TYPE = 'S'
996: and pd.DEAL_TYPE = l_deal_type

Line 1006: XTR_PARTIES_V p,

1002: cursor BROKER_DFLTS is
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

Line 1027: XTR_PARTIES_V p,

1023: cursor TAX_DFLTS is
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

Line 1127: v_party_type Xtr_Parties_V.Party_Type%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)
1131: from XTR_MASTER_CURRENCIES_V s

Line 1353: XTR_PARTIES_V c

1349: b.RATE_BASIS,
1350: nvl(b.MARGIN,0)
1351: from XTR_ROLLOVER_TRANSACTIONS a,
1352: XTR_DEALS b,
1353: XTR_PARTIES_V c
1354: where a.deal_type = NVL(p_deal_type,a.deal_type)
1355: and a.deal_type in ('TMM','IRS')
1356: and a.company_code = NVL(p_company,a.company_code)
1357: and a.company_code = c.party_code -- user access