APPS.PORCPTWF dependencies on FND_USER

Line 1609: SELECT FND.user_id

1605: instead of the employee id. The requester username is set to the buyer's
1606: username if the requester is not a user. Otherwise, it is set to the requester's
1607: username.
1608: */
1609: SELECT FND.user_id
1610: INTO x_user_id
1611: FROM FND_USER FND
1612: WHERE FND.USER_NAME = x_requester_username
1613: AND FND.START_DATE < sysdate

Line 1611: FROM FND_USER FND

1607: username.
1608: */
1609: SELECT FND.user_id
1610: INTO x_user_id
1611: FROM FND_USER FND
1612: WHERE FND.USER_NAME = x_requester_username
1613: AND FND.START_DATE < sysdate
1614: AND nvl(FND.END_DATE, sysdate + 1) >= sysdate
1615: AND ROWNUM = 1;

Line 1612: WHERE FND.USER_NAME = x_requester_username

1608: */
1609: SELECT FND.user_id
1610: INTO x_user_id
1611: FROM FND_USER FND
1612: WHERE FND.USER_NAME = x_requester_username
1613: AND FND.START_DATE < sysdate
1614: AND nvl(FND.END_DATE, sysdate + 1) >= sysdate
1615: AND ROWNUM = 1;
1616: EXCEPTION

Line 1624: from fnd_user_resp_groups fur,

1620:
1621: BEGIN
1622: select MIN(fr.responsibility_id)
1623: into x_resp_id
1624: from fnd_user_resp_groups fur,
1625: fnd_responsibility_vl fr,
1626: financials_system_parameters fsp
1627: where fur.user_id = x_user_id
1628: and fur.responsibility_application_id in (x_ip_resp_appl_id, x_po_resp_appl_id)

Line 1649: from fnd_user_resp_groups fur,

1645: if (x_resp_id = -1) THEN
1646: BEGIN
1647: select MIN(fr.responsibility_id)
1648: into x_resp_id
1649: from fnd_user_resp_groups fur,
1650: fnd_responsibility_vl fr,
1651: financials_system_parameters fsp
1652: where fur.user_id = x_user_id
1653: and fur.responsibility_id = fr.responsibility_id

Line 1674: FROM fnd_user_resp_groups fur,

1670: if(x_resp_id <> -1) then
1671: BEGIN
1672: SELECT MIN(responsibility_application_id)
1673: INTO x_resp_appl_id
1674: FROM fnd_user_resp_groups fur,
1675: fnd_responsibility_vl fr,
1676: financials_system_parameters fsp
1677: WHERE
1678: fur.responsibility_id = fr.responsibility_id and