DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APPL dependencies on IGS_FI_APP_RULES

Line 556: CURSOR cur_app_rules(cp_appl_hierarchy_id igs_fi_app_rules.appl_hierarchy_id%TYPE)

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

Line 559: FROM igs_fi_app_rules_v

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:

Line 566: CURSOR cur_adl_app_rules(cp_appl_hierarchy_id igs_fi_app_rules.appl_hierarchy_id%TYPE)

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