APPS.PQH_SS_WORKFLOW dependencies on FND_USER

Line 2045: l_userName FND_USER.user_name%Type;

2041: --
2042: l_activity NUMBER;
2043: l_itemType VARCHAR2(30);
2044: l_itemKey VARCHAR2(30);
2045: l_userName FND_USER.user_name%Type;
2046: l_ntfId NUMBER;
2047: l_lastDefaultApprover NUMBER;
2048: dummy varchar2(10);
2049:

Line 2065: fnd_user pth

2061: --
2062: CURSOR cur_appr IS
2063: SELECT pth.employee_id
2064: FROM pqh_ss_approval_history pah,
2065: fnd_user pth
2066: WHERE pah.user_name = pth.user_name
2067: AND pah.transaction_history_id = p_txnId
2068: AND approval_history_id = (
2069: SELECT MAX(approval_history_id)

Line 2071: fnd_user pth1

2067: AND pah.transaction_history_id = p_txnId
2068: AND approval_history_id = (
2069: SELECT MAX(approval_history_id)
2070: FROM pqh_ss_approval_history pah1,
2071: fnd_user pth1
2072: WHERE pah1.user_name = pth1.user_name
2073: AND pah1.transaction_history_id = pah.transaction_history_id
2074: AND pth1.employee_id IN (
2075: SELECT pth2.employee_id --, pth2.user_name, approval_history_id

Line 2077: fnd_user pth2

2073: AND pah1.transaction_history_id = pah.transaction_history_id
2074: AND pth1.employee_id IN (
2075: SELECT pth2.employee_id --, pth2.user_name, approval_history_id
2076: FROM pqh_ss_approval_history pah2,
2077: fnd_user pth2
2078: WHERE pah2.user_name = pth2.user_name
2079: AND pah2.transaction_history_id = pah.transaction_history_id
2080: AND approval_history_id < (
2081: SELECT MIN(approval_history_id)

Line 2143: from fnd_user

2139: --l_userName := p_userName; -- fix for bug 4481775
2140: if(p_userId is not null) then
2141: select user_name
2142: into l_userName
2143: from fnd_user
2144: where employee_id=p_userId;
2145: end if;
2146:
2147: END IF;