APPS.POS_CHANGE_PROM_DATES dependencies on FND_USER

Line 825: from fnd_user where user_id = x_supplier_userid;

821: avalue => x_vendor_name);
822:
823: select user_name
824: into x_supplier_username
825: from fnd_user where user_id = x_supplier_userid;
826:
827: if x_supplier_username is null then
828:
829: -- get suplier user id

Line 1459: SELECT FND.user_id

1455: x_resp_appl_id NUMBER := 201;
1456:
1457: BEGIN
1458: begin
1459: SELECT FND.user_id
1460: INTO x_user_id
1461: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
1462: WHERE HR.EMPLOYEE_ID = x_employee_id
1463: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID

Line 1461: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR

1457: BEGIN
1458: begin
1459: SELECT FND.user_id
1460: INTO x_user_id
1461: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
1462: WHERE HR.EMPLOYEE_ID = x_employee_id
1463: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
1464: AND ROWNUM = 1;
1465:

Line 1480: from fnd_user_resp_groups fur,

1476: if x_resp_id is NULL then
1477:
1478: select MIN(fr.responsibility_id)
1479: into x_resp_id
1480: from fnd_user_resp_groups fur,
1481: fnd_responsibility fr,
1482: financials_system_params_all fsp
1483: where fur.user_id = x_user_id
1484: and fur.responsibility_application_id = x_resp_appl_id