[Home] [Help]
446: l_rcr_cer_id number;
447: l_rcr_cer_ovn number;
448: l_count number := 0;
449: cursor c_matx_rates is select distinct rate.criteria_rate_defn_id
450: from pqh_rate_matrix_rates_f rate, pqh_rate_matrix_nodes node
451: where node.pl_id = p_rate_matrix_id
452: and node.rate_matrix_node_id = rate.rate_matrix_node_id
453: and p_effective_date between effective_start_date and effective_end_date;
454: l_min varchar2(150);
558: p_min out nocopy number,
559: p_mid out nocopy number,
560: p_max out nocopy number,
561: p_rate out nocopy number) is
562: l_rate_rec pqh_rate_matrix_rates_f%rowtype;
563: begin
564: select *
565: into l_rate_rec
566: from pqh_rate_matrix_rates_f
562: l_rate_rec pqh_rate_matrix_rates_f%rowtype;
563: begin
564: select *
565: into l_rate_rec
566: from pqh_rate_matrix_rates_f
567: where rate_matrix_node_id = p_rate_matrix_node_id
568: and criteria_rate_defn_id = p_crit_rate_defn_id
569: and p_effective_date between effective_start_date and effective_end_date;
570: p_min := l_rate_rec.min_rate_value;
1592: p_rmr_tr_name in varchar2,
1593: p_rmr_tr_id in number) is
1594: l_rmr_cer_id number;
1595: l_rmr_cer_ovn number;
1596: cursor c_node_rate is select * from pqh_rate_matrix_rates_f
1597: where rate_matrix_node_id = p_rate_matrix_node_id
1598: and p_effective_date between effective_start_date and effective_end_date;
1599: begin
1600: hr_utility.set_location('inside copying node_rate ',10);