APPS.XTR_REPLICATE_BANK_BALANCES dependencies on XTR_MASTER_CURRENCIES_V

Line 338: l_round_factor XTR_MASTER_CURRENCIES_V.ROUNDING_FACTOR%TYPE;

334: l_rounding_type xtr_bank_accounts.rounding_type%TYPE;
335: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
336: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE;
337:
338: l_round_factor XTR_MASTER_CURRENCIES_V.ROUNDING_FACTOR%TYPE;
339: l_yr_basis XTR_MASTER_CURRENCIES_V.YEAR_BASIS%TYPE;
340: l_hce_rate XTR_MASTER_CURRENCIES_V.HCE_RATE%TYPE;
341:
342: l_prv_prv_day_count_type XTR_BANK_BALANCES.day_count_type%TYPE;

Line 339: l_yr_basis XTR_MASTER_CURRENCIES_V.YEAR_BASIS%TYPE;

335: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
336: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE;
337:
338: l_round_factor XTR_MASTER_CURRENCIES_V.ROUNDING_FACTOR%TYPE;
339: l_yr_basis XTR_MASTER_CURRENCIES_V.YEAR_BASIS%TYPE;
340: l_hce_rate XTR_MASTER_CURRENCIES_V.HCE_RATE%TYPE;
341:
342: l_prv_prv_day_count_type XTR_BANK_BALANCES.day_count_type%TYPE;
343: l_oldest_date XTR_BANK_BALANCES.balance_date%TYPE;

Line 340: l_hce_rate XTR_MASTER_CURRENCIES_V.HCE_RATE%TYPE;

336: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE;
337:
338: l_round_factor XTR_MASTER_CURRENCIES_V.ROUNDING_FACTOR%TYPE;
339: l_yr_basis XTR_MASTER_CURRENCIES_V.YEAR_BASIS%TYPE;
340: l_hce_rate XTR_MASTER_CURRENCIES_V.HCE_RATE%TYPE;
341:
342: l_prv_prv_day_count_type XTR_BANK_BALANCES.day_count_type%TYPE;
343: l_oldest_date XTR_BANK_BALANCES.balance_date%TYPE;
344:

Line 385: FROM XTR_MASTER_CURRENCIES_V

381:
382: -- Get the details of the rounding factor for the currency
383: CURSOR CURRENCY_RNDING IS
384: SELECT ROUNDING_FACTOR,YEAR_BASIS,HCE_RATE
385: FROM XTR_MASTER_CURRENCIES_V
386: WHERE CURRENCY = l_ccy;
387:
388:
389: