DBA Data[Home] [Help]

APPS.PER_SPS_INS dependencies on PER_GRADE_SPINES_F

Line 456: ,per_grade_spines_f pgs

452: select pps.name
453: ,psp.spinal_point
454: ,pgs.grade_id
455: from per_parent_spines pps
456: ,per_grade_spines_f pgs
457: ,per_spinal_points psp
458: where pgs.grade_spine_id = p_rec.grade_spine_id
459: and p_effective_date between
460: pgs.effective_start_date and pgs.effective_end_date

Line 700: ,p_parent_table_name1 => 'per_grade_spines_f'

696: ,p_datetrack_mode => p_datetrack_mode
697: ,p_base_table_name => 'per_spinal_point_steps_f'
698: ,p_base_key_column => 'step_id'
699: ,p_base_key_value => p_rec.step_id
700: ,p_parent_table_name1 => 'per_grade_spines_f'
701: ,p_parent_key_column1 => 'grade_spine_id'
702: ,p_parent_key_value1 => p_rec.grade_spine_id
703: ,p_enforce_foreign_locking => true
704: ,p_validation_start_date => l_validation_start_date