APPS.PER_PGS_BUS dependencies on PER_SPINAL_POINT_STEPS_F

Line 431: -- exist in table per_spinal_point_steps_f.

427: -- ---------------------------------------------------------------------------
428: --
429: -- Description:
430: -- If ceiling_step_id is not NULL, it must
431: -- exist in table per_spinal_point_steps_f.
432: --
433: -- Pre-conditions:
434: -- parent_spine_id must be valid.
435: -- business_group_id must be valid.

Line 482: from per_spinal_point_steps_f

478: */
479:
480: cursor csr_valid_spinal_point_step is
481: select null
482: from per_spinal_point_steps_f
483: where business_group_id = p_business_group_id
484: and step_id = p_ceiling_step_id
485: and p_effective_date between effective_start_date
486: and effective_end_date;

Line 697: -- per_spinal_point_steps_f, per_spinal_point_placement_f and

693: -- ---------------------------------------------------------------------------
694: --
695: -- Description
696: -- This procedure is used to check that there are no values in
697: -- per_spinal_point_steps_f, per_spinal_point_placement_f and
698: -- per_all_assignments_f.
699: --
700: -- Pre Conditions
701: -- None.

Line 730: from per_spinal_point_steps_f sps

726: l_exists varchar2(1);
727: --
728: cursor csr_spinal_point_placements is
729: select 'x'
730: from per_spinal_point_steps_f sps
731: ,per_grade_spines_f gs
732: where gs.grade_spine_id = sps.grade_spine_id
733: and gs.parent_spine_id = p_parent_spine_id
734: and gs.grade_id = p_grade_id

Line 742: from per_spinal_point_steps_f sps

738: where sp.step_id = sps.step_id);
739:
740: cursor csr_assignments is
741: select 'x'
742: from per_spinal_point_steps_f sps
743: ,per_grade_spines_f gs
744: where gs.grade_spine_id = sps.grade_spine_id
745: and gs.parent_spine_id = p_parent_spine_id
746: and gs.grade_id = p_grade_id

Line 758: -- Check there are no values in per_spinal_point_steps_f

754: Begin
755: --
756: hr_utility.set_location('Entering:'||l_proc, 10);
757: --
758: -- Check there are no values in per_spinal_point_steps_f
759: -- and per_spinal_point_placements_f
760: --
761: open csr_spinal_point_placements;
762: --

Line 1050: (p_base_table_name => 'per_spinal_point_steps_f'

1046: -- when validate_mode is ZAP, the following validation isn't required.
1047: --
1048: /*
1049: If (dt_api.rows_exist
1050: (p_base_table_name => 'per_spinal_point_steps_f'
1051: ,p_base_key_column => 'grade_spine_id'
1052: ,p_base_key_value => p_grade_spine_id
1053: ,p_from_date => p_validation_start_date
1054: ,p_to_date => p_validation_end_date