[Home] [Help]
50:
51: -- get the currency code
52: CURSOR cur_ctrl IS
53: SELECT currency_cd
54: FROM igs_fi_control_all;
55:
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
53: SELECT currency_cd
54: FROM igs_fi_control_all;
55:
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