APPS.PQH_SS_WORKFLOW dependencies on FND_USER

Line 2068: l_userName FND_USER.user_name%Type;

2064: --
2065: l_activity NUMBER;
2066: l_itemType VARCHAR2(30);
2067: l_itemKey VARCHAR2(30);
2068: l_userName FND_USER.user_name%Type;
2069: l_ntfId NUMBER;
2070: l_lastDefaultApprover NUMBER;
2071: dummy varchar2(10);
2072:

Line 2088: fnd_user pth

2084: --
2085: CURSOR cur_appr IS
2086: SELECT pth.employee_id
2087: FROM pqh_ss_approval_history pah,
2088: fnd_user pth
2089: WHERE pah.user_name = pth.user_name
2090: AND pah.transaction_history_id = p_txnId
2091: AND approval_history_id = (
2092: SELECT MAX(approval_history_id)

Line 2094: fnd_user pth1

2090: AND pah.transaction_history_id = p_txnId
2091: AND approval_history_id = (
2092: SELECT MAX(approval_history_id)
2093: FROM pqh_ss_approval_history pah1,
2094: fnd_user pth1
2095: WHERE pah1.user_name = pth1.user_name
2096: AND pah1.transaction_history_id = pah.transaction_history_id
2097: AND pth1.employee_id IN (
2098: SELECT pth2.employee_id --, pth2.user_name, approval_history_id

Line 2100: fnd_user pth2

2096: AND pah1.transaction_history_id = pah.transaction_history_id
2097: AND pth1.employee_id IN (
2098: SELECT pth2.employee_id --, pth2.user_name, approval_history_id
2099: FROM pqh_ss_approval_history pah2,
2100: fnd_user pth2
2101: WHERE pah2.user_name = pth2.user_name
2102: AND pah2.transaction_history_id = pah.transaction_history_id
2103: AND approval_history_id < (
2104: SELECT MIN(approval_history_id)

Line 2166: from fnd_user

2162: --l_userName := p_userName; -- fix for bug 4481775
2163: if(p_userId is not null) then
2164: select user_name
2165: into l_userName
2166: from fnd_user
2167: where employee_id=p_userId;
2168: end if;
2169:
2170: END IF;