eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_PRC_APPL dependencies on IGS_FI_A_HIERARCHIES

Line 547: CURSOR cur_hierarchies(cp_appl_hierarchy_id igs_fi_a_hierarchies.credit_type_id%TYPE)

543: FOR UPDATE NOWAIT;
544:
545: -- cursor for getting the application hierarchy id for the given credit type id
546: --changed this cursor to sort by version number to get the latest record.
547: CURSOR cur_hierarchies(cp_appl_hierarchy_id igs_fi_a_hierarchies.credit_type_id%TYPE)
548: IS
549: SELECT appl_hierarchy_id, hierarchy_name, effective_start_date, effective_end_date
550: FROM igs_fi_a_hierarchies
551: WHERE appl_hierarchy_id = cp_appl_hierarchy_id

Line 550: FROM igs_fi_a_hierarchies

546: --changed this cursor to sort by version number to get the latest record.
547: CURSOR cur_hierarchies(cp_appl_hierarchy_id igs_fi_a_hierarchies.credit_type_id%TYPE)
548: IS
549: SELECT appl_hierarchy_id, hierarchy_name, effective_start_date, effective_end_date
550: FROM igs_fi_a_hierarchies
551: WHERE appl_hierarchy_id = cp_appl_hierarchy_id
552: ORDER by version_number desc;
553:
554: -- cursor for getting all the fee types ordered based on the rule sequence identified