APPS.PER_PQH_SHR dependencies on PER_ALL_ASSIGNMENTS_F

Line 39: per_all_assignments_f

35: --
36: cursor c_assignment(p_assignment_id number, p_effective_date date) is
37: select organization_id, business_group_id
38: from
39: per_all_assignments_f
40: where
41: assignment_id = p_assignment_id
42: and p_effective_date between effective_start_date and effective_end_date;
43: --

Line 576: from per_all_assignments_f

572:
573: Cursor C_Pos_Per_Exist(p_position_id in number,p_start_date in date, p_end_date in date)
574: is
575: Select assignment_id
576: from per_all_assignments_f
577: where position_id = p_position_id
578: and effective_start_date = p_start_date
579: and effective_end_date = p_end_date;
580:

Line 735: from per_all_assignments_f

731: l_eff_end_date date;
732:
733: /*cursor get_eff_st_date(c_pos_id number) is
734: select min(effective_start_date) into l_effective_start_date
735: from per_all_assignments_f
736: where assignment_id = l_assignment_id
737: and assignment_type = 'E'
738: and position_id = c_pos_id;*/
739:

Line 742: from per_all_assignments_f

738: and position_id = c_pos_id;*/
739:
740: cursor get_eff_st_date(c_pos_id in number ,c_curr_start_date in date ) is
741: select min(effective_start_date) into l_effective_start_date
742: from per_all_assignments_f
743: where assignment_id = l_assignment_id
744: and assignment_type = 'E'
745: and position_id = c_pos_id
746: and effective_start_date <= c_curr_start_date

Line 748: from per_all_assignments_f

744: and assignment_type = 'E'
745: and position_id = c_pos_id
746: and effective_start_date <= c_curr_start_date
747: and effective_start_date > nvl((select max(effective_start_date)
748: from per_all_assignments_f
749: where assignment_id = l_assignment_id
750: and position_id not in (c_pos_id)
751: and effective_start_date < c_curr_start_date),(effective_start_date-1));
752:

Line 755: from per_all_assignments_f

751: and effective_start_date < c_curr_start_date),(effective_start_date-1));
752:
753: cursor get_eff_st_date2(c_pos_id in number , c_assg_start_date in date) is
754: select min(effective_start_date) into l_effective_start_date
755: from per_all_assignments_f
756: where assignment_id = l_assignment_id
757: and assignment_type = 'E'
758: and position_id = c_pos_id
759: and effective_start_date > nvl((select max(effective_start_date)

Line 760: from per_all_assignments_f

756: where assignment_id = l_assignment_id
757: and assignment_type = 'E'
758: and position_id = c_pos_id
759: and effective_start_date > nvl((select max(effective_start_date)
760: from per_all_assignments_f
761: where assignment_id = l_assignment_id
762: and position_id not in (c_pos_id)
763: and effective_start_date < c_assg_start_date),(effective_start_date-1));
764:

Line 768: FROM per_all_assignments_f ass

764:
765: cursor get_user_name (p_person_id in number,p_effective_start_date in date,p_old_position_id in number)
766: is
767: SELECT usr.user_name,usr.start_date,end_date
768: FROM per_all_assignments_f ass
769: , fnd_user usr
770: WHERE ass.person_id = usr.employee_id
771: and ass.person_id = p_person_id
772: --AND p_effective_start_date BETWEEN usr.start_date AND nvl (usr.end_date, p_effective_start_date)

Line 1050: from PER_ALL_ASSIGNMENTS_F ASS,

1046: FNDT.NLS_TERRITORY TERRITORY,
1047: PER.EMAIL_ADDRESS EMAIL_ADDRESS,
1048: NULL FAX,
1049: 'ACTIVE' STATUS
1050: from PER_ALL_ASSIGNMENTS_F ASS,
1051: PER_ALL_POSITIONS POS,
1052: FND_USER USR,
1053: PER_ALL_PEOPLE_F PER,
1054: FND_TERRITORIES FNDT,