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

Line 429: FROM PER_ALL_ASSIGNMENTS_F

425: /* The following cursor is added to replace the select statement to get assignment dates.
426: Bug 1994421 "Zero Work Days build */
427: CURSOR assignment_date_cur IS
428: SELECT min(effective_start_date), max(effective_end_date)
429: FROM PER_ALL_ASSIGNMENTS_F
430: WHERE assignment_id = v_assignment_id
431: AND assignment_type ='E'; --Added for bug 2624259
432:
433:

Line 447: from PER_ALL_ASSIGNMENTS_F a

443:
444: /* The following code is commented for bug 1994421,"Zero Work days build " */
445: /* select min(a.effective_start_date),max(a.effective_end_date)
446: into assignment_start_date,assignment_end_date
447: from PER_ALL_ASSIGNMENTS_F a
448: where a.assignment_id = v_Assignment_id
449: and assignment_status_type_id IN (select distinct assignment_status_type_id
450: from per_assignment_status_types
451: where per_system_status = 'ACTIVE_ASSIGN') */