APPS.PQH_GSP_HR_TO_STAGE dependencies on PAY_GRADE_RULES_F

Line 2647: from pay_grade_rules_f

2643: hr_utility.set_location('Rate passed is '||l_pay_rule_id,40);
2644: begin
2645: select value,minimum,mid_value,maximum
2646: into p_grd_value,p_grd_min,p_grd_mid,p_grd_max
2647: from pay_grade_rules_f
2648: where grade_rule_id = l_pay_rule_id
2649: and grade_or_spinal_point_id = p_grade_id
2650: and p_effective_date between effective_start_date and effective_end_date
2651: and rate_type ='G';

Line 2694: from pay_grade_rules_f

2690: hr_utility.set_location('Rate passed is '||l_grd_pay_rate_id,40);
2691: begin
2692: select value,minimum,mid_value,maximum
2693: into p_grd_value,p_grd_min,p_grd_mid,p_grd_max
2694: from pay_grade_rules_f
2695: where rate_id = l_grd_pay_rate_id
2696: and grade_or_spinal_point_id = p_grade_id
2697: and p_effective_date between effective_start_date and effective_end_date
2698: and rate_type ='G';

Line 2743: from pay_grade_rules_f

2739: hr_utility.set_location('Rate passed is '||l_pay_rule_id,40);
2740: begin
2741: select value
2742: into p_point_value
2743: from pay_grade_rules_f
2744: where grade_rule_id = l_pay_rule_id
2745: and grade_or_spinal_point_id = p_point_id
2746: and p_effective_date between effective_start_date and effective_end_date
2747: and rate_type ='SP';

Line 2805: from pay_grade_rules_f

2801: hr_utility.set_location('Rate passed is '||l_scl_pay_rate_id,40);
2802: begin
2803: select value
2804: into p_point_value
2805: from pay_grade_rules_f
2806: where rate_id = l_scl_pay_rate_id
2807: and grade_or_spinal_point_id = p_point_id
2808: and p_effective_date between effective_start_date and effective_end_date
2809: and rate_type ='SP';

Line 3012: from pay_grade_rules_f

3008: p_grd_max out nocopy number) is
3009: begin
3010: select maximum, mid_value,minimum,value
3011: into p_grd_max,p_grd_mid, p_grd_min,p_grd_value
3012: from pay_grade_rules_f
3013: where grade_rule_id = p_pay_rule_id
3014: and rate_type ='G'
3015: and grade_or_spinal_point_id = p_grade_id
3016: and p_effective_date between effective_start_date and effective_end_date;

Line 3034: from pay_grade_rules_f

3030: p_point_value out nocopy number) is
3031: begin
3032: select value
3033: into p_point_value
3034: from pay_grade_rules_f
3035: where grade_rule_id = p_pay_rule_id
3036: and rate_type ='SP'
3037: and grade_or_spinal_point_id = p_point_id
3038: and p_effective_date between effective_start_date and effective_end_date;

Line 5657: select * from pay_grade_rules_f

5653: procedure pull_payrate(p_copy_entity_txn_id in number,
5654: p_payrate_id in number,
5655: p_effective_date in date) is
5656: cursor csr_grd_rt is
5657: select * from pay_grade_rules_f
5658: where rate_id = p_payrate_id
5659: and p_effective_date between effective_start_date and effective_end_date;
5660: l_hrr_cer_id number;
5661: l_abr_cer_id number;