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.PQP_US_SRS_EXTRACTS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 394: from per_assignment_status_types

390: ,p_status_code In out nocopy Varchar2) Return Number Is
391: Cursor cur_status_name
392: (c_assignment_status_type_id In per_all_assignments_f.assignment_status_type_id%TYPE) Is
393: select user_status
394: from per_assignment_status_types
395: where assignment_status_type_id = c_assignment_status_type_id;
396:
397: l_assig_status per_assignment_status_types.user_status%TYPE;
398: l_assig_type_id per_all_assignments_f.assignment_status_type_id%TYPE;

Line 397: l_assig_status per_assignment_status_types.user_status%TYPE;

393: select user_status
394: from per_assignment_status_types
395: where assignment_status_type_id = c_assignment_status_type_id;
396:
397: l_assig_status per_assignment_status_types.user_status%TYPE;
398: l_assig_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
399: l_proc_name varchar2(150) := g_proc_name ||'.Get_Assig_Status';
400: l_error varchar2(500);
401: -- nocopy changes