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.PA_ASGMT_WFSTD dependencies on PA_RES_APRVL_ROLES_V

Line 6332: FROM pa_res_aprvl_roles_v ar

6328: -- asmt according to the resource/staffing manager. Resource/staffing mgr should
6329: -- see the # of asmt which is related to only their resources.
6330: SELECT count(*)
6331: INTO l_num_apr_asgns
6332: FROM pa_res_aprvl_roles_v ar
6333: WHERE ar.notified_id = l_notified_id
6334: AND ar.group_id = p_group_id
6335: AND ar.approval_status = 'ASGMT_APPRVL_APPROVED';
6336:

Line 6339: FROM pa_res_aprvl_roles_v ar

6335: AND ar.approval_status = 'ASGMT_APPRVL_APPROVED';
6336:
6337: SELECT count(*)
6338: INTO l_num_rej_asgns
6339: FROM pa_res_aprvl_roles_v ar
6340: WHERE ar.notified_id = l_notified_id
6341: AND ar.group_id = p_group_id
6342: AND ar.approval_status = 'ASGMT_APPRVL_REJECTED';
6343: ELSE