APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PER_SPINAL_POINTS

Line 2859: l_spinal_point per_spinal_points.spinal_point%TYPE;

2855: l_second_sal_code VARCHAR2(2);
2856: l_third_sal_code VARCHAR2(2);
2857: l_location_id NUMBER;
2858: l_exists VARCHAR2(1);
2859: l_spinal_point per_spinal_points.spinal_point%TYPE;
2860: i NUMBER;
2861: l_tp1_nested_level NUMBER;
2862: -- RET2.a
2863: l_count NUMBER; --Loop counter

Line 3208: -- Get spinal point id from per_spinal_points

3204: FETCH csr_get_sf_spinal_point INTO l_spinal_point;
3205: CLOSE csr_get_sf_spinal_point;
3206: ELSE -- safeguarded information not specified
3207: debug(l_proc_name,350);
3208: -- Get spinal point id from per_spinal_points
3209: OPEN csr_get_spinal_point (l_assignment_id
3210: ,l_teacher_start_date
3211: );
3212: FETCH csr_get_spinal_point INTO l_spinal_point;