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_ASSIGNMENTS_F2_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 631: from per_all_assignments_f a

627: from per_periods_of_service pos
628: where pos.period_of_service_id = P_PD_OS_ID
629: and exists (
630: select null
631: from per_all_assignments_f a
632: where a.assignment_id = P_ASS_ID
633: and a.effective_start_date = pos.date_start);
634: --
635: cursor chk_ass is

Line 637: from per_all_assignments_f a

633: and a.effective_start_date = pos.date_start);
634: --
635: cursor chk_ass is
636: select 1
637: from per_all_assignments_f a
638: where a.assignment_id <> P_ASS_ID
639: and a.person_id = P_PER_ID
640: and a.assignment_type = 'E'
641: and exists (

Line 911: from per_all_assignments_f

907: ,vendor_site_id
908: ,po_header_id
909: ,po_line_id
910: ,projected_assignment_end
911: from per_all_assignments_f
912: where assignment_id = p_asg_id
913: and p_eff_date between effective_start_date
914: and effective_end_date;
915: --

Line 1323: from per_all_assignments_f

1319: ,vendor_site_id
1320: ,po_header_id
1321: ,po_line_id
1322: ,projected_assignment_end
1323: from per_all_assignments_f
1324: where assignment_id = p_asg_id
1325: and p_eff_date between effective_start_date
1326: and effective_end_date;
1327: --