APPS.GHR_WF_PKG dependencies on GHR_GROUPBOX_USERS

Line 1335: from ghr_groupbox_users

1331: AUTHORIZER_FLAG,
1332: PERSONNELIST_FLAG,
1333: APPROVER_FLAG,
1334: REVIEWER_FLAG
1335: from ghr_groupbox_users
1336: where groupbox_id = ( select groupbox_id from ghr_groupboxes
1337: where routing_group_id = l_routing_group_id )
1338: and user_name = l_forward_to_name;
1339:

Line 1403: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;

1399: from ghr_pa_requests
1400: where pa_request_id = itemkey;
1401:
1402: l_valid_user varchar2(1) := 'N';
1403: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;
1404: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE := NULL;
1405: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
1406: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;