APPS.HR_ASSIGNMENT dependencies on PER_ALL_PEOPLE_F

Line 593: from per_all_people_f

589: end
590: ) into ass_seq
591: from per_all_assignments_f
592: where person_id = (select distinct person_id
593: from per_all_people_f
594: where employee_number = p_worker_number
595: and business_group_id = p_business_group_id)
596: and business_group_id + 0 = p_business_group_id;*/
597: --Added for bug 6633320

Line 608: from per_all_people_f

604: end
605: ),2) into ass_seq
606: from per_all_assignments_f
607: where person_id = (select distinct person_id
608: from per_all_people_f
609: where employee_number = p_worker_number
610: and business_group_id = p_business_group_id)
611: and business_group_id = p_business_group_id
612: and instr(assignment_number,p_worker_number||'-',1) > 0;

Line 622: from per_all_people_f

618: end
619: ),2) into ass_seq
620: from per_all_assignments_f
621: where person_id = (select distinct person_id
622: from per_all_people_f
623: where npw_number = p_worker_number
624: and business_group_id = p_business_group_id)
625: and business_group_id = p_business_group_id
626: and instr(assignment_number,p_worker_number||'-',1) > 0;

Line 5307: PER_ALL_PEOPLE_F SUP ,

5303: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL ,
5304: PAY_ALL_PAYROLLS_F PAY ,
5305: HR_LOCATIONS_ALL_TL LOCTL ,
5306: HR_LOCATIONS_NO_JOIN LOC ,
5307: PER_ALL_PEOPLE_F SUP ,
5308: PER_SPINAL_POINT_STEPS_F PSPS ,
5309: PER_SPINAL_POINTS PSP ,
5310: HR_ALL_ORGANIZATION_UNITS O ,
5311: HR_ALL_ORGANIZATION_UNITS_TL OTL ,