[Home] [Help]
844: || (reverse chronological order - newest change first)
845: */
846: CURSOR discrepancy_rule_cur IS
847: SELECT *
848: FROM igs_ad_source_cat
849: WHERE source_type_id = p_source_type_id
850: AND category_name = p_category;
851: discrepancy_rule_rec discrepancy_rule_cur%ROWTYPE;
852: l_disp_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
848: FROM igs_ad_source_cat
849: WHERE source_type_id = p_source_type_id
850: AND category_name = p_category;
851: discrepancy_rule_rec discrepancy_rule_cur%ROWTYPE;
852: l_disp_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
853:
854: BEGIN
855:
856: OPEN discrepancy_rule_cur;