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 635: from per_all_assignments_f a

631: from per_periods_of_service pos
632: where pos.period_of_service_id = P_PD_OS_ID
633: and exists (
634: select null
635: from per_all_assignments_f a
636: where a.assignment_id = P_ASS_ID
637: and a.effective_start_date = pos.date_start);
638: --
639: cursor chk_ass is

Line 641: from per_all_assignments_f a

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

Line 917: from per_all_assignments_f

913: ,vendor_site_id
914: ,po_header_id
915: ,po_line_id
916: ,projected_assignment_end
917: from per_all_assignments_f
918: where assignment_id = p_asg_id
919: and p_eff_date between effective_start_date
920: and effective_end_date;
921: --

Line 1341: from per_all_assignments_f

1337: ,vendor_site_id
1338: ,po_header_id
1339: ,po_line_id
1340: ,projected_assignment_end
1341: from per_all_assignments_f
1342: where assignment_id = p_asg_id
1343: and p_eff_date between effective_start_date
1344: and effective_end_date;
1345: --