812:
813: CURSOR c_grouping_rule
814: IS
815: SELECT grouping_rule_id
816: FROM pn_pay_group_rules
817: WHERE name=p_grouping_rule;
818:
819: CURSOR c_grouping_rule_id
820: IS
818:
819: CURSOR c_grouping_rule_id
820: IS
821: SELECT grouping_rule_id
822: FROM pn_pay_group_rules
823: WHERE grouping_rule_id=x_grouping_rule_id;
824: BEGIN
825: -- Initialize the return status.
826: x_return_status := fnd_api.g_ret_sts_success;