APPS.GHR_WF_PKG dependencies on GHR_GROUPBOX_USERS

Line 1357: from ghr_groupbox_users

1353: AUTHORIZER_FLAG,
1354: PERSONNELIST_FLAG,
1355: APPROVER_FLAG,
1356: REVIEWER_FLAG
1357: from ghr_groupbox_users
1358: where groupbox_id = ( select groupbox_id from ghr_groupboxes
1359: where routing_group_id = l_routing_group_id )
1360: and user_name = l_forward_to_name;
1361:

Line 1425: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;

1421: from ghr_pa_requests
1422: where pa_request_id = itemkey;
1423:
1424: l_valid_user varchar2(1) := 'N';
1425: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1426: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1427: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1428: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;