APPS.OKC_REP_SIGN_WF_PVT dependencies on FND_USER

Line 351: FROM po_vendor_contacts pvc,FND_USER f

347:
348:
349: CURSOR cur_supplier_user(p_contact_id IN number) IS
350: SELECT f.user_name ,(pvc.first_name || ' ' || pvc.middle_name || ' ' || pvc.last_name) contact_name
351: FROM po_vendor_contacts pvc,FND_USER f
352: where pvc.PER_PARTY_ID= f.person_party_id
353: AND pvc.vendor_contact_id=p_contact_id;
354:
355: CURSOR cur_cust_user(p_contact_id IN NUMBER,p_object_id IN number) IS

Line 359: FND_USER f

355: CURSOR cur_cust_user(p_contact_id IN NUMBER,p_object_id IN number) IS
356: SELECT f.user_name ,( hz.person_first_name||' '||hz.person_last_name ) contact_name FROM
357: hz_relationships hr,
358: hz_parties hz,
359: FND_USER f
360: WHERE
361: hr.party_id = p_contact_id
362: AND hr.subject_id = hz.party_id
363: AND hr.object_id = p_object_id

Line 378: fnd_user f

374:
375: CURSOR cur_int_user(p_contact_id IN NUMBER) is
376: SELECT f.user_name,p.full_name contact_name from
377: per_workforce_v p,
378: fnd_user f
379: WHERE f.employee_id(+)=p.person_id and
380: p.person_id=p_contact_id;
381:
382: CURSOR cur_contract_admin IS

Line 385: fnd_user f

381:
382: CURSOR cur_contract_admin IS
383: SELECT f.user_name FROM
384: OKC_REP_CONTRACTS_ALL okr ,
385: fnd_user f
386: WHERE okr.contract_id=p_contract_id
387: AND okr.owner_id=f.user_id;
388:
389:

Line 908: l_recipient_name FND_USER.user_name%type;

904: l_contract_id okc_rep_signature_details.contract_id%type;
905: l_contract_version okc_rep_signature_details.contract_version_num%type;
906: l_signer_id number;
907: l_sign_status VARCHAR2(30);
908: l_recipient_name FND_USER.user_name%type;
909: l_action_code okc_rep_signature_details.action_code%type;
910: l_wf_note VARCHAR2(2000);
911: l_api_name VARCHAR2(30);
912: l_return_status VARCHAR2(1);

Line 923: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1

919:
920: CURSOR notif_csr (p_notification_id NUMBER) IS
921: SELECT fu.user_id user_id, fu.user_name user_name,
922: fu1.user_id original_user_id,fu1.user_name original_user_name
923: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
924: WHERE fu.user_name = wfn.recipient_role
925: AND fu1.user_name = wfn.original_recipient
926: AND wfn.notification_id = p_notification_id ;
927: