APPS.PER_QH_MAINTAIN_UPDATE dependencies on PAY_PGR_SHD

Line 5213: AND ( nvl(pay_pgr_shd.g_old_rec.currency_code,hr_api.g_varchar2)

5209: p_rate_effective_start_date := l_rate_effective_start_date;
5210: p_rate_effective_end_date := l_rate_effective_end_date;
5211: ELSIF p_grade_rule_id is not null
5212: AND p_rate_id is not null
5213: AND ( nvl(pay_pgr_shd.g_old_rec.currency_code,hr_api.g_varchar2)
5214: <>nvl(p_rate_currency_code,hr_api.g_varchar2)
5215: OR nvl(pay_pgr_shd.g_old_rec.value,hr_api.g_varchar2)
5216: <>nvl(p_rate_value,hr_api.g_varchar2) )
5217: THEN

Line 5215: OR nvl(pay_pgr_shd.g_old_rec.value,hr_api.g_varchar2)

5211: ELSIF p_grade_rule_id is not null
5212: AND p_rate_id is not null
5213: AND ( nvl(pay_pgr_shd.g_old_rec.currency_code,hr_api.g_varchar2)
5214: <>nvl(p_rate_currency_code,hr_api.g_varchar2)
5215: OR nvl(pay_pgr_shd.g_old_rec.value,hr_api.g_varchar2)
5216: <>nvl(p_rate_value,hr_api.g_varchar2) )
5217: THEN
5218: hr_utility.set_location(l_proc, 1020);
5219: hr_rate_values_api.update_assignment_rate_value

Line 7198: pay_pgr_shd.lck

7194: ELSE
7195: l_rate_datetrack_update_mode:=p_datetrack_update_mode;
7196: END IF;
7197: --
7198: pay_pgr_shd.lck
7199: (p_effective_date => p_effective_date
7200: ,p_datetrack_mode => l_rate_datetrack_update_mode
7201: ,p_grade_rule_id => p_grade_rule_id
7202: ,p_object_version_number => p_rate_object_version_number