APPS.PER_SPP_INS dependencies on PER_ALL_ASSIGNMENTS_F

Line 459: from per_all_assignments_f paa

455: select paa.assignment_id
456: ,paa.effective_start_date
457: ,paa.effective_end_date
458: ,paa.grade_id
459: from per_all_assignments_f paa
460: where paa.assignment_id = p_assignment_id
461: and paa.effective_start_date between p_start_date and p_end_date
462: order by paa.effective_start_date;
463: --

Line 469: from per_all_assignments_f paa

465: --
466: Cursor change_grade_update(p_assignment_id number, p_asg_eff_start_date date,
467: p_grade_id number) IS
468: select 'Y'
469: from per_all_assignments_f paa
470: where paa.assignment_id = p_assignment_id
471: and paa.effective_end_date = (p_asg_eff_start_date-1)
472: and paa.grade_id <> p_grade_id
473: and p_grade_id is not null

Line 483: from per_all_assignments_f paa

479: --
480: Cursor same_grade_update(p_assignment_id number, p_asg_eff_start_date date,
481: p_grade_id number) IS
482: select 'Y'
483: from per_all_assignments_f paa
484: where paa.assignment_id = p_assignment_id
485: and paa.effective_end_date = (p_asg_eff_start_date-1)
486: and paa.grade_id = p_grade_id;
487: --

Line 495: from per_all_assignments_f paa

491: --
492: Cursor change_grade_to_null(p_assignment_id number, p_asg_eff_start_date date,
493: p_grade_id number) IS
494: select 'Y'
495: from per_all_assignments_f paa
496: where paa.assignment_id = p_assignment_id
497: and paa.effective_end_date = (p_asg_eff_start_date-1)
498: and paa.grade_id is not null
499: and p_grade_id is null;

Line 516: l_assignment_id per_all_assignments_f.assignment_id%type;

512: --
513: --
514: --
515: l_proc varchar2(72) := g_package||'sync_spp_asg';
516: l_assignment_id per_all_assignments_f.assignment_id%type;
517: l_placement_id per_spinal_point_placements_f.placement_id%type;
518: l_future_spp_id per_spinal_point_placements_f.placement_id%type;
519: l_end_date DATE;
520: l_validation_start_date DATE;

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

974: ,p_base_key_value => p_rec.placement_id
975: ,p_parent_table_name1 => 'per_spinal_point_steps_f'
976: ,p_parent_key_column1 => 'step_id'
977: ,p_parent_key_value1 => p_rec.step_id
978: -- ,p_parent_table_name2 => 'per_all_assignments_f'
979: -- ,p_parent_key_column2 => 'assignment_id'
980: -- ,p_parent_key_value2 => p_rec.assignment_id
981: ,p_enforce_foreign_locking => l_enforce_foreign_locking
982: ,p_validation_start_date => l_validation_start_date1

Line 997: ,p_parent_table_name2 => 'per_all_assignments_f'

993: ,p_base_key_value => p_rec.placement_id
994: --,p_parent_table_name1 => 'per_spinal_point_steps_f'
995: --,p_parent_key_column1 => 'step_id'
996: --,p_parent_key_value1 => p_rec.step_id
997: ,p_parent_table_name2 => 'per_all_assignments_f'
998: ,p_parent_key_column2 => 'assignment_id'
999: ,p_parent_key_value2 => p_rec.assignment_id
1000: ,p_enforce_foreign_locking => true
1001: ,p_validation_start_date => l_validation_start_date2

Line 1176: per_all_assignments_f paa

1172: --
1173: cursor chk_step_valid_for_grade is
1174: select parent_spine_id
1175: from per_grade_spines_f pgs,
1176: per_all_assignments_f paa
1177: where paa.grade_id = pgs.grade_id
1178: and paa.assignment_id = p_assignment_id
1179: and p_effective_date between paa.effective_start_date
1180: and paa.effective_end_date