APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PER_SPINAL_POINTS

Line 2866: l_spinal_point per_spinal_points.spinal_point%TYPE;

2862: l_second_sal_code VARCHAR2(2);
2863: l_third_sal_code VARCHAR2(2);
2864: l_location_id NUMBER;
2865: l_exists VARCHAR2(1);
2866: l_spinal_point per_spinal_points.spinal_point%TYPE;
2867: i NUMBER;
2868: l_tp1_nested_level NUMBER;
2869: -- RET2.a
2870: l_count NUMBER; --Loop counter

Line 3222: -- Get spinal point id from per_spinal_points

3218: FETCH csr_get_sf_spinal_point INTO l_spinal_point;
3219: CLOSE csr_get_sf_spinal_point;
3220: ELSE -- safeguarded information not specified
3221: debug(l_proc_name,350);
3222: -- Get spinal point id from per_spinal_points
3223: OPEN csr_get_spinal_point (l_assignment_id
3224: ,l_teacher_start_date
3225: );
3226: FETCH csr_get_spinal_point INTO l_spinal_point;