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_PARTY_DEFAULTS

Line 863: from XTR_PARTY_DEFAULTS pd,

859: cursor SETTLE_DFLTS is
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'

Line 877: from XTR_PARTY_DEFAULTS b,

873: --
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

Line 898: from XTR_PARTY_DEFAULTS b,

894: --
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

Line 991: from XTR_PARTY_DEFAULTS pd,

987: cursor SETTLE_DFLTS is
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'

Line 1005: from XTR_PARTY_DEFAULTS b,

1001: --
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

Line 1026: from XTR_PARTY_DEFAULTS b,

1022: --
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