DBA Data[Home] [Help]

APPS.PER_PSP_BUS dependencies on PER_SPINAL_POINT_STEPS_F

Line 506: -- per_grade_spines_f, per_spinal_point_steps_f and pay_grade_rules_f

502: -- ---------------------------------------------------------------------------
503: --
504: -- Description
505: -- This procedure is used to check that there are no values in
506: -- per_grade_spines_f, per_spinal_point_steps_f and pay_grade_rules_f
507: --
508: -- Pre Conditions
509: -- None.
510: --

Line 538: from per_spinal_point_steps_f sps

534: l_exists varchar2(1);
535: --
536: cursor csr_step_grade_spine is
537: select 'x'
538: from per_spinal_point_steps_f sps
539: ,per_grade_spines_f pgs
540: where sps.grade_spine_id = pgs.grade_spine_id
541: and pgs.parent_spine_id = p_parent_spine_id
542: and sps.spinal_point_id = p_spinal_point_id;

Line 556: -- Check there are no values in per_spinal_point_steps_f and

552: --
553: hr_utility.set_location('Entering:'||l_proc, 10);
554:
555: --
556: -- Check there are no values in per_spinal_point_steps_f and
557: -- per_grade_spines_f
558: --
559: open csr_step_grade_spine;
560: --