APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on FND_USER

Line 172: from AMW_EMPLOYEES_CURRENT_V aecv, FND_USER fu

168: fnd_file.put_line (fnd_file.LOG, 'Entered the Procedure');
169:
170: -- To fetch the party id
171: select aecv.party_id into v_party_id
172: from AMW_EMPLOYEES_CURRENT_V aecv, FND_USER fu
173: where aecv.EMPLOYEE_ID = fu.EMPLOYEE_ID
174: and fu.user_id = G_USER_ID;
175:
176: --To Update the initial values

Line 312: select person_party_id into v_emp_id from fnd_user where user_id = g_user_id;

308: END LOOP;
309:
310: -- To fetch the party Id from User Id
311: fnd_file.put_line (fnd_file.LOG, 'User Id' || g_user_id);
312: select person_party_id into v_emp_id from fnd_user where user_id = g_user_id;
313: fnd_file.put_line (fnd_file.LOG, 'Start Updating the details');
314:
315: fnd_file.put_line (fnd_file.LOG, 'Updating procedure status');
316: -- To Update the audit procedure status