48: --
49: l_proc VARCHAR2(72) := g_package||'create_rate';
50: l_effective_date DATE;
51: l_object_version_number NUMBER;
52: l_rate_id pay_rates.rate_id%TYPE;
53: -- Bug 3795968 Starts Here
54: CURSOR csr_full_hr_installed IS
55: SELECT null
56: FROM fnd_product_installations i
856: --
857: l_proc VARCHAR2(72) := g_package||'create_assignment_rate';
858: l_effective_date DATE;
859: l_object_version_number NUMBER;
860: l_rate_id pay_rates.rate_id%TYPE;
861: l_default_rate_type pay_rates.rate_type%TYPE;
862: l_default_rate_uom pay_rates.rate_uom%TYPE;
863: --
864: BEGIN
857: l_proc VARCHAR2(72) := g_package||'create_assignment_rate';
858: l_effective_date DATE;
859: l_object_version_number NUMBER;
860: l_rate_id pay_rates.rate_id%TYPE;
861: l_default_rate_type pay_rates.rate_type%TYPE;
862: l_default_rate_uom pay_rates.rate_uom%TYPE;
863: --
864: BEGIN
865: --
858: l_effective_date DATE;
859: l_object_version_number NUMBER;
860: l_rate_id pay_rates.rate_id%TYPE;
861: l_default_rate_type pay_rates.rate_type%TYPE;
862: l_default_rate_uom pay_rates.rate_uom%TYPE;
863: --
864: BEGIN
865: --
866: hr_utility.set_location('Entering:'|| l_proc, 10);