DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on PA_RES_APRVL_ROLES_V

Line 6348: FROM pa_res_aprvl_roles_v ar

6344: -- asmt according to the resource/staffing manager. Resource/staffing mgr should
6345: -- see the # of asmt which is related to only their resources.
6346: SELECT count(*)
6347: INTO l_num_apr_asgns
6348: FROM pa_res_aprvl_roles_v ar
6349: WHERE ar.notified_id = l_notified_id
6350: AND ar.group_id = p_group_id
6351: AND ar.approval_status = 'ASGMT_APPRVL_APPROVED';
6352:

Line 6355: FROM pa_res_aprvl_roles_v ar

6351: AND ar.approval_status = 'ASGMT_APPRVL_APPROVED';
6352:
6353: SELECT count(*)
6354: INTO l_num_rej_asgns
6355: FROM pa_res_aprvl_roles_v ar
6356: WHERE ar.notified_id = l_notified_id
6357: AND ar.group_id = p_group_id
6358: AND ar.approval_status = 'ASGMT_APPRVL_REJECTED';
6359: ELSE