DBA Data[Home] [Help]

APPS.XTR_COF_P dependencies on XTR_MASTER_CURRENCIES_V

Line 61: from XTR_MASTER_CURRENCIES_V s

57: ) as
58: ---
59: cursor HCE is
60: select s.HCE_RATE,s.ROUNDING_FACTOR
61: from XTR_MASTER_CURRENCIES_V s
62: where s.CURRENCY = P_CURRENCY;
63:
64: L_HCE_BASE_REF_AMOUNT NUMBER;
65: L_REF_DATE DATE;

Line 208: from XTR_MASTER_CURRENCIES_V

204: T_COF_ROWID DBMS_SQL.VARCHAR2_TABLE;
205:
206: cursor get_rounding_factor(l_in_currency in varchar2) is
207: select hce_rate,rounding_factor
208: from XTR_MASTER_CURRENCIES_V
209: where currency=l_in_currency;
210:
211: cursor CHK_LOCK_ROWS_COF_IG(V_START_DATE DATE,
212: V_END_DATE DATE,

Line 1001: from XTR_MASTER_CURRENCIES_V s

997:
998: ---
999: cursor HCE is
1000: select s.HCE_RATE,s.ROUNDING_FACTOR
1001: from XTR_MASTER_CURRENCIES_V s
1002: where s.CURRENCY = P_CURRENCY;
1003:
1004: --
1005: L_HCE_BASE_REF_AMOUNT NUMBER;

Line 1667: from XTR_MASTER_CURRENCIES_V

1663: l_interest_hce NUMBER;
1664:
1665: cursor get_rounding_factor is
1666: select hce_rate,rounding_factor
1667: from XTR_MASTER_CURRENCIES_V
1668: where currency=l_currency;
1669:
1670: BEGIN
1671: /**************/