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 572: from per_all_assignments_f

568: l_cnt number;
569:
570: cursor get_eff_st_date(c_pos_id number) is
571: select min(effective_start_date) into l_effective_start_date
572: from per_all_assignments_f
573: where assignment_id = l_assignment_id
574: and assignment_type = 'E'
575: and position_id = c_pos_id;
576: begin

Line 658: from PER_ALL_ASSIGNMENTS_F ASS,

654: FNDT.NLS_TERRITORY TERRITORY,
655: PER.EMAIL_ADDRESS EMAIL_ADDRESS,
656: NULL FAX,
657: 'ACTIVE' STATUS
658: from PER_ALL_ASSIGNMENTS_F ASS,
659: PER_ALL_POSITIONS POS,
660: FND_USER USR,
661: PER_ALL_PEOPLE_F PER,
662: FND_TERRITORIES FNDT,