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.PER_PERRPFP3_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 503: from per_all_assignments_f asg,

499: v_detailcount number(10);
500: begin
501: select count(*)
502: into v_detailcount
503: from per_all_assignments_f asg,
504: per_all_people_f peo
505: where asg.supervisor_id = peo.person_id(+)
506: and asg.effective_start_date between peo.effective_start_date(+)
507: and peo.effective_end_date(+)

Line 519: per_all_assignments_f pa

515: begin
516: select count(*)
517: into v_detailcount
518: from per_secondary_ass_statuses ast,
519: per_all_assignments_f pa
520: where ast.assignment_id = pa.assignment_id
521: and pa.person_id = p_person_id
522: and pa.business_group_id = p_business_group_id;
523:

Line 534: per_all_assignments_f pa

530:
531: select count(*)
532: into v_detailcount
533: from per_spinal_point_placements_f pssp,
534: per_all_assignments_f pa
535: where pssp.assignment_id = pa.assignment_id
536: and pa.person_id = p_person_id
537: and pa.business_group_id = p_business_group_id;
538: return v_detailcount;