APPS.IGS_FI_GEN_GL dependencies on IGS_FI_CONTROL

Line 54: FROM igs_fi_control_all;

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

Line 57: CURSOR c_curr_desc(cp_currency_cd IN igs_fi_control_all.currency_cd%TYPE

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

Line 98: l_v_currency_cd igs_fi_control_v.currency_cd%TYPE;

94: Change History
95: Who When What
96: ******************************************************************/
97:
98: l_v_currency_cd igs_fi_control_v.currency_cd%TYPE;
99: l_v_currency_desc igs_fi_control_v.name%TYPE;
100: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
101:
102: BEGIN

Line 99: l_v_currency_desc igs_fi_control_v.name%TYPE;

95: Who When What
96: ******************************************************************/
97:
98: l_v_currency_cd igs_fi_control_v.currency_cd%TYPE;
99: l_v_currency_desc igs_fi_control_v.name%TYPE;
100: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
101:
102: BEGIN
103:

Line 139: CURSOR cur_acct_mth(cp_v_accounting_mthd IN igs_fi_control.accounting_method%TYPE) IS

135: ******************************************************************/
136:
137:
138: --Cursor to validate the accounting method param
139: CURSOR cur_acct_mth(cp_v_accounting_mthd IN igs_fi_control.accounting_method%TYPE) IS
140: SELECT lookup_code
141: FROM igs_lookup_values
142: WHERE lookup_code = cp_v_accounting_mthd
143: AND lookup_type = 'IGS_FI_ACCT_METHOD'

Line 197: l_v_accounting_method igs_fi_control.accounting_method%TYPE;

193: AND invln.posting_id IS NULL
194: AND invln.posting_control_id IS NULL;
195:
196:
197: l_v_accounting_method igs_fi_control.accounting_method%TYPE;
198: l_v_exist VARCHAR2(1);
199:
200: BEGIN
201: