521: ) is
522:
523: --
524: l_crd_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
525: l_crd_name pqh_criteria_rate_defn.short_name%type;
526: l_rate_matrix_node_id pqh_rate_matrix_rates_f.rate_matrix_node_id%type;
527: l_rt_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
528: l_pl_id ben_pl_f.pl_id%type;
529: l_pl_name ben_pl_f.short_code%type;
826: where short_name = p_short_name
827: and business_group_id = l_business_group_id;
828: --
829: Cursor csr_crd_seq is
830: Select pqh_criteria_rate_defn_s.nextval
831: From dual;
832: Begin
833: --
834: -- populate WHO columns