DBA Data[Home] [Help]

APPS.HR_RATE_VALUES_API dependencies on PAY_RATES

Line 39: l_rate_uom pay_rates.rate_uom%TYPE;

35: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
36: l_effective_date DATE;
37: l_proc VARCHAR2(72) := g_package||'create_rate_value';
38: --
39: l_rate_uom pay_rates.rate_uom%TYPE;
40: l_currency_code pay_grade_rules_f.currency_code%TYPE;
41: --
42: cursor csr_get_rate_uom is
43: select rate_uom

Line 44: from pay_rates

40: l_currency_code pay_grade_rules_f.currency_code%TYPE;
41: --
42: cursor csr_get_rate_uom is
43: select rate_uom
44: from pay_rates
45: where rate_id = p_rate_id;
46: --
47: cursor csr_get_curr_code is
48: select currency_code

Line 602: l_rate_uom pay_rates.rate_uom%TYPE;

598: l_effective_date DATE;
599: l_default_rate_type pay_grade_rules_f.rate_type%TYPE;
600: l_proc VARCHAR2(72) := g_package||'create_assignment_rate_value';
601: --
602: l_rate_uom pay_rates.rate_uom%TYPE;
603: l_currency_code pay_grade_rules_f.currency_code%TYPE;
604: --
605: cursor csr_get_rate_uom is
606: select rate_uom

Line 607: from pay_rates

603: l_currency_code pay_grade_rules_f.currency_code%TYPE;
604: --
605: cursor csr_get_rate_uom is
606: select rate_uom
607: from pay_rates
608: where rate_id = p_rate_id;
609: --
610: cursor csr_get_curr_code is
611: select currency_code