APPS.HR_RATE_VALUES_SWI dependencies on PAY_GRADE_RULES_F

Line 935: from pay_grade_rules_f pgr

931: asg_id NUMBER, effective_date date) is
932: select currency_code,
933: value,
934: effective_end_date
935: from pay_grade_rules_f pgr
936: where pgr.grade_rule_id = nvl(grade_id, -1)
937: and pgr.rate_type = 'A'
938: and pgr.business_group_id = business_gp_id
939: and pgr.grade_or_spinal_point_id = asg_id

Line 1521: (p_associated_column1 => 'PAY_GRADE_RULES_F.EFFECTIVE_END_DATE');

1517: if trunc(p_asg_rate_rec.effective_start_date) > trunc(nvl(p_asg_rate_rec.effective_end_date, hr_api.g_eot))
1518: then
1519: hr_utility.set_message(800, 'HR_ASG_RATE_INV_END_DATE');
1520: l_temp := hr_multi_message.exception_add
1521: (p_associated_column1 => 'PAY_GRADE_RULES_F.EFFECTIVE_END_DATE');
1522: end if;
1523: hr_multi_message.end_validation_set;
1524: end if;
1525: