APPS.PER_ASSIGNMENTS_F3_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 395: update per_all_assignments_f a

391: -- assignments with the same id as the current one to have the same new
392: -- assignment number.
393: --
394: if p_s_ass_number <> p_ass_number then
395: update per_all_assignments_f a
396: set a.assignment_number = P_ASS_NUMBER
397: where a.business_group_id + 0 = P_BG_ID
398: and a.rowid <> P_ROW_ID
399: and a.assignment_id = P_ASS_ID;

Line 546: select max(effective_end_date ) from per_all_assignments_f

542: and g.grade_id= P_GRD_ID
543: and g.grade_spine_id=s.grade_spine_id ;
544:
545: cursor get_asg_enddate is
546: select max(effective_end_date ) from per_all_assignments_f
547: where assignment_id= P_ASS_ID
548: -- and grade_id=P_GRD_ID
549: and assignment_type='E';
550:

Line 558: FROM per_all_assignments_f

554: CURSOR get_leg_code IS
555: SELECT legislation_code
556: FROM per_business_groups
557: WHERE business_group_id = (SELECT business_group_id
558: FROM per_all_assignments_f
559: WHERE assignment_id = p_ass_id
560: and effective_start_date <= p_eff_st_date
561: and effective_end_date >= p_eff_st_date);
562: