APPS.PQH_RBC_STAGE dependencies on PQH_CRITERIA_RATE_DEFN

Line 461: l_currency_code pqh_criteria_rate_defn.currency_code%type;

457: l_rate varchar2(150);
458: l_calc_mthd varchar2(150);
459: l_comp_flag varchar2(150);
460: l_crit_name varchar2(250);
461: l_currency_code pqh_criteria_rate_defn.currency_code%type;
462: l_uom pqh_criteria_rate_defn.uom%type;
463: begin
464: hr_utility.set_location('inside copying matrix_rates ',10);
465: for matx_rate in c_matx_rates loop

Line 462: l_uom pqh_criteria_rate_defn.uom%type;

458: l_calc_mthd varchar2(150);
459: l_comp_flag varchar2(150);
460: l_crit_name varchar2(250);
461: l_currency_code pqh_criteria_rate_defn.currency_code%type;
462: l_uom pqh_criteria_rate_defn.uom%type;
463: begin
464: hr_utility.set_location('inside copying matrix_rates ',10);
465: for matx_rate in c_matx_rates loop
466: hr_utility.set_location('copying matx_rate to staging'||l_count,20);

Line 470: from pqh_criteria_rate_defn_vl

466: hr_utility.set_location('copying matx_rate to staging'||l_count,20);
467: begin
468: select define_min_rate_flag,define_mid_rate_flag,define_max_rate_flag,define_std_rate_flag,rate_calc_cd, name,currency_code,uom
469: into l_min,l_mid,l_max,l_rate,l_calc_mthd,l_crit_name,l_currency_code,l_uom
470: from pqh_criteria_rate_defn_vl
471: where criteria_rate_defn_id = matx_rate.criteria_rate_defn_id;
472: exception
473: when others then
474: hr_utility.set_location('issue in getting rate defn det',30);

Line 538: from pqh_criteria_rate_defn

534: p_rate := l_rate_rec.information297;
535: begin
536: select currency_code,reference_period_cd
537: into p_currency_cd,p_freq_cd
538: from pqh_criteria_rate_defn
539: where criteria_rate_defn_id = p_crit_rate_defn_id;
540: exception
541: when no_data_found then
542: hr_utility.set_location('crit rate not exists ',15);

Line 618: l_crit_rate_rec pqh_criteria_rate_defn%rowtype;

614: p_rate_c out nocopy varchar2) is
615: cursor crit_rate_factors (p_criteria_rate_defn_id number) is
616: select * from pqh_criteria_rate_factors
617: where criteria_rate_defn_id = p_criteria_rate_defn_id;
618: l_crit_rate_rec pqh_criteria_rate_defn%rowtype;
619: l_rate_min number;
620: l_rate_mid number;
621: l_rate_max number;
622: l_rate_value number;

Line 638: from pqh_criteria_rate_defn

634: hr_utility.set_location('get computed value for RMN'||p_rmn_cer_id,10);
635: hr_utility.set_location(' CRT'||p_rate_defn_id,10);
636: begin
637: select * into l_crit_rate_rec
638: from pqh_criteria_rate_defn
639: where criteria_rate_defn_id = p_rate_defn_id;
640: exception
641: when no_data_found then
642: hr_utility.set_location('no rate exists'||p_rate_defn_id,20);