APPS.XTR_IG_TRANSFERS_PKG dependencies on XTR_INTERGROUP_TRANSFERS_V

Line 199: from xtr_intergroup_transfers_v

195: p_pricing_model VARCHAR2) is
196: -----------------------------------------------------------------------------------------------------
197: cursor get_pricing_model is
198: select pricing_model, deal_number
199: from xtr_intergroup_transfers_v
200: where company_code = p_company_code
201: and party_code = p_party_code
202: and currency = p_currency;
203:

Line 234: from xtr_intergroup_transfers_v

230: p_pricing_model OUT NOCOPY VARCHAR2) is
231: -----------------------------------------------------------------------------------------------------
232: cursor get_pricing_model is
233: select pricing_model
234: from xtr_intergroup_transfers_v
235: where company_code = p_company_code
236: and party_code = p_party_code
237: and currency = p_currency;
238:

Line 1107: from xtr_INTERGROUP_TRANSFERS_v a

1103: a.TRANSACTION_NUMBER,
1104: a.ACCRUAL_INTEREST,
1105: a.ROUNDING_TYPE, --* Add for Interest Project
1106: a.DAY_COUNT_TYPE --* Add for Interest Project
1107: from xtr_INTERGROUP_TRANSFERS_v a
1108: where a.PARTY_CODE = G_Ig_Main_Rec.PARTY_CODE
1109: and a.COMPANY_CODE = G_Ig_Main_Rec.COMPANY_CODE
1110: and a.CURRENCY = G_Ig_Main_Rec.CURRENCY
1111: and a.TRANSFER_DATE <= G_Ig_Main_Rec.TRANSFER_DATE

Line 2415: from XTR_INTERGROUP_TRANSFERS_v

2411: PORTFOLIO,
2412: nvl(ACCRUAL_INTEREST,0),
2413: ROUNDING_TYPE, --* Add for Interest Override
2414: DAY_COUNT_TYPE --* Add for Interest Override
2415: from XTR_INTERGROUP_TRANSFERS_v
2416: where PARTY_CODE = p_party_code
2417: and CURRENCY = p_currency
2418: and COMPANY_CODE = p_company_code
2419: and TRANSFER_DATE >= p_transfer_date

Line 2541: update xtr_INTERGROUP_TRANSFERS_v

2537:
2538: l_accrual_int := nvl(prv_accrual_int,0) + nvl(l_interest,0);
2539:
2540: if p_update = 'Y' then
2541: update xtr_INTERGROUP_TRANSFERS_v
2542: set BALANCE_BF = prv_bal_out,
2543: BALANCE_BF_HCE = prv_bal_out_hce,
2544: BALANCE_OUT = l_bal_out,
2545: BALANCE_OUT_HCE = l_bal_out_hce,

Line 2564: update xtr_INTERGROUP_TRANSFERS_v

2560: --* Add for Interest Project
2561: --* When this flag is set, all transaction should be recalculated and replaced by new types.
2562:
2563: if p_types_update = 'Y' and p_update ='Y' and l_count = 0 then
2564: update xtr_INTERGROUP_TRANSFERS_v
2565: set DAY_COUNT_TYPE = nvl(p_day_count_type,l_day_count_type),
2566: ROUNDING_TYPE = nvl(p_rounding_type,l_rounding_type)
2567: where rowid=l_rowid;
2568: end if;