APPS.HR_DOR_REVIEW_SS dependencies on PQH_SS_APPROVAL_HISTORY

Line 2214: from PQH_SS_APPROVAL_HISTORY

2210: from fnd_user where user_name = l_user_name;
2211: elsif ((l_user_name is not null) and (substr(l_user_name,1,3) IN ('POS','PQH') )) then /*Added PHQ for bug#14806618*/
2212: select USER_NAME
2213: into l_verified_by_user_name
2214: from PQH_SS_APPROVAL_HISTORY
2215: where transaction_history_id = p_transaction_id
2216: and creation_date = (select max(CREATION_DATE)
2217: from PQH_SS_APPROVAL_HISTORY
2218: where transaction_history_id = p_transaction_id);

Line 2217: from PQH_SS_APPROVAL_HISTORY

2213: into l_verified_by_user_name
2214: from PQH_SS_APPROVAL_HISTORY
2215: where transaction_history_id = p_transaction_id
2216: and creation_date = (select max(CREATION_DATE)
2217: from PQH_SS_APPROVAL_HISTORY
2218: where transaction_history_id = p_transaction_id);
2219:
2220: select user_id into l_verified_by
2221: from fnd_user where user_name = l_verified_by_user_name;