552: ORDER by version_number desc;
553:
554: -- cursor for getting all the fee types ordered based on the rule sequence identified
555: -- for the application hierarchy id
556: CURSOR cur_app_rules(cp_appl_hierarchy_id igs_fi_app_rules.appl_hierarchy_id%TYPE)
557: IS
558: SELECT rule_sequence, fee_type, enabled_flag
559: FROM igs_fi_app_rules_v
560: WHERE appl_hierarchy_id = cp_appl_hierarchy_id AND
555: -- for the application hierarchy id
556: CURSOR cur_app_rules(cp_appl_hierarchy_id igs_fi_app_rules.appl_hierarchy_id%TYPE)
557: IS
558: SELECT rule_sequence, fee_type, enabled_flag
559: FROM igs_fi_app_rules_v
560: WHERE appl_hierarchy_id = cp_appl_hierarchy_id AND
561: enabled_flag = 'Y'
562: ORDER BY rule_sequence;
563:
562: ORDER BY rule_sequence;
563:
564: -- cursor for getting all the fee types ordered based on the rule sequence identified
565: -- for the application hierarchy id in the Additional Authorized tab
566: CURSOR cur_adl_app_rules(cp_appl_hierarchy_id igs_fi_app_rules.appl_hierarchy_id%TYPE)
567: IS
568: SELECT rule_sequence, fee_type, enabled_flag
569: FROM igs_fi_adl_app_rul_v
570: WHERE appl_hierarchy_id = cp_appl_hierarchy_id AND