APPS.PAY_PGR_BUS dependencies on PAY_RATES

Line 95: FROM pay_rates

91: ,p_object_version_number IN pay_grade_rules_f.object_version_number%TYPE) IS
92: --
93: CURSOR csr_chk_rate IS
94: SELECT rate_id
95: FROM pay_rates
96: WHERE rate_id = p_rate_id
97: AND business_group_id = p_business_group_id;
98: --
99: CURSOR csr_duplicate_rate IS

Line 112: ,pay_rates pr1

108: --
109: CURSOR csr_dupl_asg_rate_type IS
110: SELECT pr1.rate_id
111: FROM pay_grade_rules_f pgr
112: ,pay_rates pr1
113: ,pay_rates pr2
114: WHERE pgr.grade_or_spinal_point_id = p_grade_or_spinal_point_id
115: AND ( (p_grade_rule_id IS NULL
116: AND pgr.effective_end_date > p_effective_date)

Line 113: ,pay_rates pr2

109: CURSOR csr_dupl_asg_rate_type IS
110: SELECT pr1.rate_id
111: FROM pay_grade_rules_f pgr
112: ,pay_rates pr1
113: ,pay_rates pr2
114: WHERE pgr.grade_or_spinal_point_id = p_grade_or_spinal_point_id
115: AND ( (p_grade_rule_id IS NULL
116: AND pgr.effective_end_date > p_effective_date)
117: OR (p_grade_rule_id IS NOT NULL

Line 389: l_rate_uom pay_rates.rate_uom%TYPE;

385: ,p_object_version_number IN pay_grade_rules_f.object_version_number%TYPE) IS
386: --
387: l_proc VARCHAR2(72) := g_package||'chk_currency_code';
388: l_dummy_code fnd_currencies.currency_code%TYPE;
389: l_rate_uom pay_rates.rate_uom%TYPE;
390: --
391: CURSOR csr_chk_currency_code IS
392: SELECT fc.currency_code
393: FROM fnd_currencies fc

Line 398: FROM pay_rates pr

394: WHERE fc.currency_code = p_currency_code;
395: --
396: CURSOR csr_get_rate_uom IS
397: SELECT pr.rate_uom
398: FROM pay_rates pr
399: WHERE pr.rate_id = p_rate_id;
400: --
401: BEGIN
402: --

Line 564: l_bg_id pay_rates.business_group_id%type; -- added for bug 6016428 (for backward compatibility)

560: l_rgeflg varchar2(255);
561: l_format varchar2(255);
562: l_input varchar2(255);
563: l_proc VARCHAR2(72) := g_package||'chk_values_format';
564: l_bg_id pay_rates.business_group_id%type; -- added for bug 6016428 (for backward compatibility)
565: l_bg_curr_code per_business_groups.currency_code%type; -- added for bug 6016428 (for backward compatibility)
566:
567: --
568: CURSOR csr_get_rate_uom IS

Line 570: FROM pay_rates pr

566:
567: --
568: CURSOR csr_get_rate_uom IS
569: SELECT pr.rate_uom
570: FROM pay_rates pr
571: WHERE pr.rate_id = p_rate_id;
572: --
573:
574: CURSOR csr_bg_curr_cd(l_bg_id number) IS

Line 607: from pay_rates

603: /* changes for bug 6016428 starts */
604: hr_utility.set_location('Getting business Group ID ',11);
605: select business_group_id
606: into l_bg_id
607: from pay_rates
608: where rate_id = p_rate_id;
609: --
610: hr_utility.set_location('Getting default Currency code for business Group ID ',12);
611: OPEN csr_bg_curr_cd(l_bg_id);