APPS.HR_PROCESS_ASSIGNMENT_STEP_SS dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 68: from per_spinal_point_placements_f pspp

64: l_proc varchar2(72) := g_package||'process_step_save';
65:
66: cursor last_step_change_date is
67: select max(pspp.effective_start_date)
68: from per_spinal_point_placements_f pspp
69: where pspp.placement_id=p_placement_id;
70:
71: cursor step_correction_date is
72: select null

Line 73: from per_spinal_point_placements_f pspp

69: where pspp.placement_id=p_placement_id;
70:
71: cursor step_correction_date is
72: select null
73: from per_spinal_point_placements_f pspp
74: where pspp.placement_id = p_placement_id
75: and pspp.effective_start_date = l_effective_date;
76:
77: cursor csr_assignment is

Line 91: from per_spinal_point_placements_f

87: l_effective_date between effective_start_date and effective_end_date;
88:
89: cursor csr_placement_db is
90: select step_id,reason
91: from per_spinal_point_placements_f
92: where placement_id=p_placement_id and
93: l_effective_date between effective_start_date and effective_end_date;
94:
95: cursor csr_placement is

Line 98: from per_spinal_point_placements_f

94:
95: cursor csr_placement is
96: select step_id, reason, object_version_number,
97: effective_start_date, effective_end_date
98: from per_spinal_point_placements_f
99: where placement_id = p_placement_id and
100: l_effective_date between effective_start_date and effective_end_date;
101:
102: CURSOR lc_sal_updateable_grade_ladder is