APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 1130: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg

1126: SELECT spp.assignment_id,
1127: spp.step_id,
1128: spp.effective_start_date,
1129: spp.effective_end_date
1130: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg
1131: WHERE asg.person_id = p_person_id
1132: AND (p_assignment_id IS NOT NULL OR asg.primary_flag = 'Y')
1133: AND (p_assignment_id IS NULL OR asg.assignment_id = p_assignment_id)
1134: AND p_determination_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 1139: l_step_id per_spinal_point_placements_f.step_id%TYPE;

1135: AND spp.assignment_id = asg.assignment_id
1136: AND p_determination_date BETWEEN spp.effective_start_date and spp.effective_end_date;
1137:
1138: l_assignment_id per_assignments_f.assignment_id%TYPE;
1139: l_step_id per_spinal_point_placements_f.step_id%TYPE;
1140: l_start_date DATE;
1141: l_end_date DATE;
1142: l_step_los NUMBER(22,3) := 0;
1143: l_absent_duration NUMBER(22,3) := 0;

Line 2119: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg

2115: RETURN NUMBER IS
2116:
2117: Cursor c_current_step IS
2118: SELECT spp.step_id
2119: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg
2120: WHERE asg.person_id = p_person_id
2121: AND spp.assignment_id = asg.assignment_id
2122: AND trunc(sysdate) BETWEEN spp.effective_start_date and spp.effective_end_date;
2123:

Line 2124: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;

2120: WHERE asg.person_id = p_person_id
2121: AND spp.assignment_id = asg.assignment_id
2122: AND trunc(sysdate) BETWEEN spp.effective_start_date and spp.effective_end_date;
2123:
2124: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;
2125:
2126: BEGIN
2127: OPEN c_current_step;
2128: FETCH c_current_step INTO l_curr_step_id;

Line 2151: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg

2147: Cursor Csr_asg_step IS
2148: SELECT spp.step_id,
2149: spp.effective_start_date,
2150: spp.effective_end_date
2151: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg
2152: WHERE asg.person_id = p_person_id
2153: AND asg.assignment_id = p_assignment_id
2154: AND spp.assignment_id = asg.assignment_id
2155: AND p_assg_end_date BETWEEN spp.effective_start_date and spp.effective_end_date;

Line 2165: l_step_id per_spinal_point_placements_f.step_id%TYPE;

2161: AND nvl(aei_information1,'x') = p_los_type
2162: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2163:
2164: l_assignment_id per_assignments_f.assignment_id%TYPE;
2165: l_step_id per_spinal_point_placements_f.step_id%TYPE;
2166: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;
2167: l_start_date DATE;
2168: l_end_date DATE;
2169: l_step_los NUMBER(22,3) := 0;

Line 2166: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;

2162: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2163:
2164: l_assignment_id per_assignments_f.assignment_id%TYPE;
2165: l_step_id per_spinal_point_placements_f.step_id%TYPE;
2166: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;
2167: l_start_date DATE;
2168: l_end_date DATE;
2169: l_step_los NUMBER(22,3) := 0;
2170: l_absent_duration NUMBER(22,3) := 0;

Line 2364: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;

2360: l_correction_factor NUMBER(22,3) := 0;
2361: l_prev_grade_id per_previous_jobs.pjo_information2%TYPE;
2362: l_prev_step_id per_previous_jobs.pjo_information3%TYPE;
2363: l_curr_grade_id per_assignments_f.grade_id%TYPE;
2364: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;
2365: l_emp_type per_previous_jobs.employment_category%TYPE := 'x';
2366: l_employer_type per_previous_employers.employer_type%TYPE := 'x';
2367: l_prev_empl_id per_previous_employers.previous_employer_id%TYPE;
2368: l_person_id per_all_people_f.person_id%TYPE;