DBA Data[Home] [Help]

APPS.IGS_FI_GEN_GL dependencies on FND_CURRENCIES

Line 29: g_old_reference fnd_currencies%ROWTYPE;

25: | SYKRISHN 05-NOV/2002 New Package created for generic |
26: | procedures and functions |
27: | as per GL Interface TD. |
28: *=======================================================================*/
29: g_old_reference fnd_currencies%ROWTYPE;
30:
31:
32: PROCEDURE finp_get_cur ( p_v_currency_cd OUT NOCOPY VARCHAR2,
33: p_v_curr_desc OUT NOCOPY VARCHAR2,

Line 46: while selecting currency from fnd_currencies_tl.

42: remarks :
43: Change History
44: Who When What
45: vvutukur 12-Jan-2004 Bug#3348787.Modified cursor c_curr_desc to put filter on language
46: while selecting currency from fnd_currencies_tl.
47: schodava 29-Sep-2003 Bug # 3112084 - Modified cursor cur_ctrl, to
48: fetch the currency name from fnd_currencies_tl
49: ******************************************************************/
50:

Line 48: fetch the currency name from fnd_currencies_tl

44: Who When What
45: vvutukur 12-Jan-2004 Bug#3348787.Modified cursor c_curr_desc to put filter on language
46: while selecting currency from fnd_currencies_tl.
47: schodava 29-Sep-2003 Bug # 3112084 - Modified cursor cur_ctrl, to
48: fetch the currency name from fnd_currencies_tl
49: ******************************************************************/
50:
51: -- get the currency code
52: CURSOR cur_ctrl IS

Line 60: FROM fnd_currencies_tl

56: -- Get the name of the currency
57: CURSOR c_curr_desc(cp_currency_cd IN igs_fi_control_all.currency_cd%TYPE
58: ) IS
59: SELECT name
60: FROM fnd_currencies_tl
61: WHERE currency_code = cp_currency_cd
62: AND language = USERENV('LANG');
63:
64: BEGIN