APPS.IGS_FI_PRC_REFUNDS dependencies on IGS_FI_A_HIERARCHIES

Line 276: FROM igs_fi_a_hierarchies

272: -- Cursor for fetching the Application Hierarchy for the Credit Type
273: CURSOR cur_appl_hier(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
274: cp_effective_date igs_fi_credits.effective_date%TYPE) IS
275: SELECT 'x'
276: FROM igs_fi_a_hierarchies
277: WHERE credit_type_id = cp_credit_type_id
278: AND cp_effective_date BETWEEN effective_start_date AND NVL(effective_end_date,cp_effective_date);
279:
280: -- Variables of data type as the column of a table