730: SELECT reference_number, valid_from, valid_to, parent_object_code, parent_object_id
731: FROM okl_lease_quotes_b
732: WHERE id = p_quote_id;
733:
734: CURSOR fnd_user_csr IS
735: SELECT USER_NAME
736: FROM FND_USER
737: WHERE USER_ID = fnd_global.user_id;
738:
732: WHERE id = p_quote_id;
733:
734: CURSOR fnd_user_csr IS
735: SELECT USER_NAME
736: FROM FND_USER
737: WHERE USER_ID = fnd_global.user_id;
738:
739: -- Get the valid application id from FND
740:
853: itemkey => itemkey,
854: aname => G_WF_ITM_MESSAGE_DESCR,
855: avalue => get_quote_msg_body(itemtype, itemkey));
856:
857: OPEN fnd_user_csr;
858: FETCH fnd_user_csr INTO l_user_name ;
859: CLOSE fnd_user_csr;
860:
861: -- get the application id
854: aname => G_WF_ITM_MESSAGE_DESCR,
855: avalue => get_quote_msg_body(itemtype, itemkey));
856:
857: OPEN fnd_user_csr;
858: FETCH fnd_user_csr INTO l_user_name ;
859: CLOSE fnd_user_csr;
860:
861: -- get the application id
862:
855: avalue => get_quote_msg_body(itemtype, itemkey));
856:
857: OPEN fnd_user_csr;
858: FETCH fnd_user_csr INTO l_user_name ;
859: CLOSE fnd_user_csr;
860:
861: -- get the application id
862:
863: OPEN c_get_app_id_csr;