eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ASSIGNMENT dependencies on PER_ALL_PEOPLE_F

Line 580: from per_all_people_f

576: end
577: ) into ass_seq
578: from per_all_assignments_f
579: where person_id = (select distinct person_id
580: from per_all_people_f
581: where employee_number = p_worker_number
582: and business_group_id = p_business_group_id)
583: and business_group_id + 0 = p_business_group_id;*/
584: --Added for bug 6633320

Line 593: from per_all_people_f

589: end
590: ),2) 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 decode(p_assignment_type,'E',employee_number,'C',npw_number) = p_worker_number --Modified for bug 6711256
595: and business_group_id = p_business_group_id)
596: and business_group_id + 0 = p_business_group_id
597: and instr(assignment_number,p_worker_number||'-',1) > 0;

Line 5263: PER_ALL_PEOPLE_F SUP ,

5259: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL ,
5260: PAY_ALL_PAYROLLS_F PAY ,
5261: HR_LOCATIONS_ALL_TL LOCTL ,
5262: HR_LOCATIONS_NO_JOIN LOC ,
5263: PER_ALL_PEOPLE_F SUP ,
5264: PER_SPINAL_POINT_STEPS_F PSPS ,
5265: PER_SPINAL_POINTS PSP ,
5266: HR_ALL_ORGANIZATION_UNITS O ,
5267: HR_ALL_ORGANIZATION_UNITS_TL OTL ,