[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rate_id
FROM pay_rates
WHERE rate_id = p_rate_id
AND business_group_id = p_business_group_id;
SELECT rate_id
FROM pay_grade_rules_f pgr
WHERE pgr.rate_id = p_rate_id
AND pgr.grade_or_spinal_point_id = p_grade_or_spinal_point_id
AND ( (p_grade_rule_id IS NULL
AND pgr.effective_end_date > p_effective_date)
OR (p_grade_rule_id IS NOT NULL
AND pgr.grade_rule_id <> p_grade_rule_id));
SELECT pr1.rate_id
FROM pay_grade_rules_f pgr
,pay_rates pr1
,pay_rates pr2
WHERE pgr.grade_or_spinal_point_id = p_grade_or_spinal_point_id
AND ( (p_grade_rule_id IS NULL
AND pgr.effective_end_date > p_effective_date)
OR (p_grade_rule_id IS NOT NULL
AND pgr.grade_rule_id <> p_grade_rule_id
AND p_effective_date BETWEEN pgr.effective_start_date
AND pgr.effective_end_date))
AND pgr.rate_type = 'A'
AND pgr.rate_id = pr1.rate_id
AND p_rate_type = 'A'
AND p_rate_id = pr2.rate_id
AND nvl(pr2.asg_rate_type,'X') = nvl(pr1.asg_rate_type,'Y');
SELECT paf.assignment_id
FROM per_assignments_f PAF
WHERE paf.business_group_id = p_business_group_id
AND paf.assignment_id = l_assignment_id
AND paf.assignment_type = 'C'
AND p_effective_date BETWEEN paf.effective_start_date
AND paf.effective_end_date;
SELECT g.grade_id
FROM per_grades g
WHERE g.grade_id = l_grade_id
AND p_effective_date BETWEEN g.date_from
AND nvl(g.date_to, p_effective_date + 1)
AND g.business_group_id = p_business_group_id; -- Bug 3640364
SELECT spinal_point_id psp
FROM per_spinal_points psp
WHERE psp.business_group_id = p_business_group_id
AND psp.spinal_point_id = l_spinal_point_id;
SELECT fc.currency_code
FROM fnd_currencies fc
WHERE fc.currency_code = p_currency_code;
SELECT pr.rate_uom
FROM pay_rates pr
WHERE pr.rate_id = p_rate_id;
SELECT pr.rate_uom
FROM pay_rates pr
WHERE pr.rate_id = p_rate_id;
SELECT org_information10
FROM hr_organization_information hoi
WHERE hoi.organization_id = l_bg_id
AND hoi.org_information_context = 'Business Group Information'
AND hoi.org_information2 IS NOT NULL
AND EXISTS
( SELECT NULL
FROM hr_org_info_types_by_class oitbc,
hr_organization_information org_info
WHERE org_info.organization_id = hoi.organization_id
AND org_info.org_information_context = 'CLASS'
AND org_info.org_information2 = 'Y'
AND oitbc.org_classification = org_info.org_information1
AND oitbc.org_information_type = 'Business Group Information'
);
select business_group_id
into l_bg_id
from pay_rates
where rate_id = p_rate_id;
select pbg.security_group_id
from per_business_groups pbg
, pay_grade_rules_f pgr
where pgr.grade_rule_id = p_grade_rule_id
and pbg.business_group_id = pgr.business_group_id;
select pbg.legislation_code
from per_business_groups pbg
, pay_grade_rules_f pgr
where pgr.grade_rule_id = p_grade_rule_id
and pbg.business_group_id = pgr.business_group_id;
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in pay_pgr_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
Procedure dt_update_validate
(p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
) Is
--
l_proc varchar2(72) := g_package||'dt_update_validate';
End dt_update_validate;
Procedure dt_delete_validate
(p_grade_rule_id in number
,p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
) Is
--
l_proc varchar2(72) := g_package||'dt_delete_validate';
If (p_datetrack_mode = hr_api.g_delete or
p_datetrack_mode = hr_api.g_zap) then
--
hr_utility.set_location('Entering:'||l_proc, 30);
End dt_delete_validate;
Procedure insert_validate
(p_rec in pay_pgr_shd.g_rec_type
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_rec in pay_pgr_shd.g_rec_type
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
) is
--
l_proc varchar2(72) := g_package||'update_validate';
dt_update_validate
(p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
);
chk_non_updateable_args
(p_effective_date => p_effective_date
,p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in pay_pgr_shd.g_rec_type
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_validation_start_date in date
,p_validation_end_date in date
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
dt_delete_validate
(p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
,p_grade_rule_id => p_rec.grade_rule_id
);
End delete_validate;