APPS.PER_SPP_SHD dependencies on PER_ALL_ASSIGNMENTS_F

Line 194: from per_all_assignments_f paa,

190: l_grade_id number;
191:
192: cursor csr_future_grade_scale is
193: select paa.grade_id
194: from per_all_assignments_f paa,
195: per_spinal_point_placements_f spp
196: where paa.assignment_id = spp.assignment_id
197: and spp.placement_id = p_base_key_value
198: and paa.effective_start_date > p_effective_date

Line 200: from per_all_assignments_f paa1

196: where paa.assignment_id = spp.assignment_id
197: and spp.placement_id = p_base_key_value
198: and paa.effective_start_date > p_effective_date
199: and paa.grade_id <> (select paa1.grade_id
200: from per_all_assignments_f paa1
201: where paa1.assignment_id = paa.assignment_id
202: and p_effective_date between paa1.effective_start_date
203: and paa1.effective_end_date);
204: --

Line 288: ,p_parent_table_name2 => 'per_all_assignments_f'

284: ,p_base_key_value => p_base_key_value
285: ,p_parent_table_name1 => 'per_spinal_point_steps_f'
286: ,p_parent_key_column1 => 'step_id'
287: ,p_parent_key_value1 => l_parent_key_value1
288: ,p_parent_table_name2 => 'per_all_assignments_f'
289: ,p_parent_key_column2 => 'assignment_id'
290: ,p_parent_key_value2 => l_parent_key_value2
291: ,p_zap => p_zap
292: ,p_delete => p_delete

Line 519: -- ,p_parent_table_name2 => 'per_all_assignments_f'

515: ,p_base_key_value => p_placement_id
516: ,p_parent_table_name1 => 'per_spinal_point_steps_f'
517: ,p_parent_key_column1 => 'step_id'
518: ,p_parent_key_value1 => per_spp_shd.g_old_rec.step_id
519: -- ,p_parent_table_name2 => 'per_all_assignments_f'
520: -- ,p_parent_key_column2 => 'assignment_id'
521: -- ,p_parent_key_value2 => per_spp_shd.g_old_rec.assignment_id
522: ,p_enforce_foreign_locking => l_enforce_foreign_locking
523: ,p_validation_start_date => l_validation_start_date1

Line 538: ,p_parent_table_name2 => 'per_all_assignments_f'

534: ,p_base_key_value => p_placement_id
535: --,p_parent_table_name1 => 'per_spinal_point_steps_f'
536: --,p_parent_key_column1 => 'step_id'
537: --,p_parent_key_value1 => per_spp_shd.g_old_rec.step_id
538: ,p_parent_table_name2 => 'per_all_assignments_f'
539: ,p_parent_key_column2 => 'assignment_id'
540: ,p_parent_key_value2 => per_spp_shd.g_old_rec.assignment_id
541: ,p_enforce_foreign_locking => true
542: ,p_validation_start_date => l_validation_start_date2