APPS.PER_PPS_BUS dependencies on PAY_RATES

Line 532: -- per_spinal_points, per_grade_spines_f and pay_rates

528: -- ---------------------------------------------------------------------------
529: --
530: -- Description
531: -- This procedure is used to check that there are no values in
532: -- per_spinal_points, per_grade_spines_f and pay_rates
533: --
534: -- Pre Conditions
535: -- None.
536: --

Line 570: cursor csr_pay_rates is

566: select 'x'
567: FROM per_grade_spines_f
568: WHERE parent_spine_id = p_parent_spine_id;
569: --
570: cursor csr_pay_rates is
571: select 'x'
572: FROM pay_rates
573: WHERE parent_spine_id = p_parent_spine_id;
574: --

Line 572: FROM pay_rates

568: WHERE parent_spine_id = p_parent_spine_id;
569: --
570: cursor csr_pay_rates is
571: select 'x'
572: FROM pay_rates
573: WHERE parent_spine_id = p_parent_spine_id;
574: --
575: --
576: Begin

Line 581: -- and pay_rates

577: --
578: hr_utility.set_location('Entering:'||l_proc, 10);
579: --
580: -- Check there are no values in per_spinal_points, per_grade_spines_f
581: -- and pay_rates
582: --
583: open csr_spinal_points;
584: --
585: fetch csr_spinal_points into l_exists;

Line 621: -- Check there are no values in pay_rates

617: --
618: hr_utility.set_location(l_proc, 30);
619:
620: --
621: -- Check there are no values in pay_rates
622: --
623: open csr_pay_rates;
624: --
625: fetch csr_pay_rates into l_exists;

Line 623: open csr_pay_rates;

619:
620: --
621: -- Check there are no values in pay_rates
622: --
623: open csr_pay_rates;
624: --
625: fetch csr_pay_rates into l_exists;
626: --
627: If csr_pay_rates%found Then

Line 625: fetch csr_pay_rates into l_exists;

621: -- Check there are no values in pay_rates
622: --
623: open csr_pay_rates;
624: --
625: fetch csr_pay_rates into l_exists;
626: --
627: If csr_pay_rates%found Then
628: --
629: close csr_pay_rates;

Line 627: If csr_pay_rates%found Then

623: open csr_pay_rates;
624: --
625: fetch csr_pay_rates into l_exists;
626: --
627: If csr_pay_rates%found Then
628: --
629: close csr_pay_rates;
630: --
631: hr_utility.set_message(801, 'PER_7923_DEL_PAR_SPN_RATE');

Line 629: close csr_pay_rates;

625: fetch csr_pay_rates into l_exists;
626: --
627: If csr_pay_rates%found Then
628: --
629: close csr_pay_rates;
630: --
631: hr_utility.set_message(801, 'PER_7923_DEL_PAR_SPN_RATE');
632: fnd_message.raise_error;
633: --

Line 636: close csr_pay_rates;

632: fnd_message.raise_error;
633: --
634: End If;
635: --
636: close csr_pay_rates;
637: hr_utility.set_location('Leaving:' || l_proc, 40);
638: --
639: end chk_delete;
640: --