APPS.PQH_GSP_BEN_VALIDATIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 183: From Per_All_Assignments_F Assgt

179:
180: Cursor csr_emp_placemnets (l_grade_id IN NUMBER)
181: IS
182: Select NULL
183: From Per_All_Assignments_F Assgt
184: Where Grade_Id = l_grade_id
185: AND p_Effective_Date BETWEEN Assgt.effective_start_date
186: AND nvl(Assgt.effective_end_date,hr_general.end_of_time)
187: AND Assgt.business_group_id = p_Business_Group_Id;

Line 467: from per_all_assignments_f

463: and nvl(effective_end_date,hr_general.end_of_time);
464: --
465: cursor csr_emp_assign (l_step_id IN Number) is
466: select Effective_Start_Date, Effective_End_Date
467: from per_all_assignments_f
468: where special_ceiling_step_id = l_step_id
469: And Business_Group_Id= p_business_group_id
470: and p_effective_date between effective_start_date
471: and nvl(effective_end_date,hr_general.end_of_time);

Line 642: From Per_All_Assignments_F Assgt

638:
639: Cursor csr_emp_placemnets
640: IS
641: Select NULL
642: From Per_All_Assignments_F Assgt
643: Where Grade_Ladder_Pgm_Id = p_Pgm_Id
644: AND p_Effective_Date BETWEEN Assgt.effective_start_date
645: AND nvl(Assgt.effective_end_date,hr_general.end_of_time)
646: AND Assgt.business_group_id = p_Business_Group_Id;