APPS.PER_QH_MAINTAIN_UPDATE dependencies on PAY_PGR_SHD

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

5169: p_rate_effective_start_date := l_rate_effective_start_date;
5170: p_rate_effective_end_date := l_rate_effective_end_date;
5171: ELSIF p_grade_rule_id is not null
5172: AND p_rate_id is not null
5173: AND ( nvl(pay_pgr_shd.g_old_rec.currency_code,hr_api.g_varchar2)
5174: <>nvl(p_rate_currency_code,hr_api.g_varchar2)
5175: OR nvl(pay_pgr_shd.g_old_rec.value,hr_api.g_varchar2)
5176: <>nvl(p_rate_value,hr_api.g_varchar2) )
5177: THEN

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

5171: ELSIF p_grade_rule_id is not null
5172: AND p_rate_id is not null
5173: AND ( nvl(pay_pgr_shd.g_old_rec.currency_code,hr_api.g_varchar2)
5174: <>nvl(p_rate_currency_code,hr_api.g_varchar2)
5175: OR nvl(pay_pgr_shd.g_old_rec.value,hr_api.g_varchar2)
5176: <>nvl(p_rate_value,hr_api.g_varchar2) )
5177: THEN
5178: hr_utility.set_location(l_proc, 1020);
5179: hr_rate_values_api.update_assignment_rate_value

Line 7158: pay_pgr_shd.lck

7154: ELSE
7155: l_rate_datetrack_update_mode:=p_datetrack_update_mode;
7156: END IF;
7157: --
7158: pay_pgr_shd.lck
7159: (p_effective_date => p_effective_date
7160: ,p_datetrack_mode => l_rate_datetrack_update_mode
7161: ,p_grade_rule_id => p_grade_rule_id
7162: ,p_object_version_number => p_rate_object_version_number