APPS.IGS_FI_ACCT_STP_CNV dependencies on IGS_FI_HIER_ACCT_TBL

Line 219: CURSOR cur_hier(cp_n_acct_hier_id igs_fi_hier_acct_tbl.acct_hier_id%TYPE) IS

215:
216: l_v_var VARCHAR2(1);
217: l_n_seq igs_fi_ftci_accts.order_sequence%TYPE;
218:
219: CURSOR cur_hier(cp_n_acct_hier_id igs_fi_hier_acct_tbl.acct_hier_id%TYPE) IS
220: SELECT entity_type_code
221: FROM igs_fi_hier_acct_tbl
222: WHERE acct_hier_id = cp_n_acct_hier_id
223: ORDER BY order_sequence;

Line 221: FROM igs_fi_hier_acct_tbl

217: l_n_seq igs_fi_ftci_accts.order_sequence%TYPE;
218:
219: CURSOR cur_hier(cp_n_acct_hier_id igs_fi_hier_acct_tbl.acct_hier_id%TYPE) IS
220: SELECT entity_type_code
221: FROM igs_fi_hier_acct_tbl
222: WHERE acct_hier_id = cp_n_acct_hier_id
223: ORDER BY order_sequence;
224:
225: CURSOR cur_prg_rev_cd IS

Line 257: FROM igs_fi_hier_acct_tbl

253: ORDER BY org_unit_cd;
254:
255: CURSOR cur_hier_oth(cp_acct_hier_id NUMBER) IS
256: SELECT entity_type_code
257: FROM igs_fi_hier_acct_tbl
258: WHERE acct_hier_id = cp_acct_hier_id
259: AND entity_type_code IN ('FTCI','SA')
260: ORDER BY order_sequence;
261:

Line 264: FROM igs_fi_hier_acct_tbl

260: ORDER BY order_sequence;
261:
262: CURSOR cur_hier_oth_count(cp_acct_hier_id NUMBER) IS
263: SELECT COUNT(entity_type_code)
264: FROM igs_fi_hier_acct_tbl
265: WHERE acct_hier_id = cp_acct_hier_id
266: AND entity_type_code IN ('FTCI','SA');
267:
268: l_v_fee_type igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE');

Line 274: l_v_entity_code igs_fi_hier_acct_tbl.entity_type_code%TYPE;

270: l_v_acct_hierarchy igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ACCT_HIERARCHY');
271: l_v_message_text igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','MESSAGE_TEXT');
272:
273: l_v_rev_account_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE;
274: l_v_entity_code igs_fi_hier_acct_tbl.entity_type_code%TYPE;
275:
276: --For Program.
277: TYPE prg_rec_type IS RECORD (
278: course_cd igs_ps_ver.course_cd%TYPE,