APPS.PER_ASSIGNMENTS_F3_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 397: update per_all_assignments_f a

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

Line 549: select max(effective_end_date ) from per_all_assignments_f

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

Line 561: FROM per_all_assignments_f

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