DBA Data[Home] [Help]

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: