APPS.PER_GRADE_SPINES_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 504: from per_all_assignments_f a,

500: select 'x'
501: from sys.dual
502: where exists
503: (select null
504: from per_all_assignments_f a,
505: per_spinal_point_placements_f p,
506: per_spinal_point_steps_f s
507: where a.assignment_id = p.assignment_id
508: and a.effective_start_date <= p_val_start

Line 695: from per_all_assignments_f paa,

691: -- greater than the propposed end date of spinal point steps
692: --
693: cursor check_ass is
694: select 1
695: from per_all_assignments_f paa,
696: per_spinal_point_steps_f psps
697: where psps.grade_spine_id = p_gspine_id
698: and paa.special_ceiling_step_id = psps.step_id
699: and p_sess < paa.effective_end_date;

Line 850: per_all_assignments_f a

846: p_grd_id in number,
847: p_plc_start in date) is
848: select a.effective_start_date -1
849: from per_spinal_point_placements_f p,
850: per_all_assignments_f a
851: where p.placement_id = p_plc_id
852: and p.effective_start_date = p_plc_start
853: and a.assignment_id = p.assignment_id
854: and a.effective_start_date > p_plc_start

Line 863: per_all_assignments_f a

859: --
860: cursor get_assend(p_plc_id in number) is
861: select max(a.effective_end_date)
862: from per_spinal_point_placements_f p,
863: per_all_assignments_f a
864: where p.placement_id = p_plc_id
865: and p.assignment_id = a.assignment_id;
866: --
867: --