APPS.OCM_CREDIT_REQUEST_UPDATE_PUB dependencies on PER_ALL_PEOPLE_F
Line 128: FROM PER_ALL_PEOPLE_F
124: IF nvl(p_credit_request_rec.requestor_type,'EMPLOYEE')='EMPLOYEE'
125: THEN
126: BEGIN
127: SELECT 'x' INTO l_check_flag 128: FROM PER_ALL_PEOPLE_F 129: WHERE sysdate between effective_start_date and effective_end_date
130: and current_employee_flag = 'Y'
131: and person_id = p_credit_request_rec.requestor_id;
132: