APPS.OKC_REP_QA_CHECK_PVT dependencies on FND_USER

Line 587: FROM po_vendor_contacts pvc,FND_USER f

583:
584:
585: CURSOR cur_supplier_user(p_contact_id IN number) IS
586: SELECT f.user_name ,(pvc.first_name || ' ' || pvc.middle_name || ' ' || pvc.last_name) contact_name
587: FROM po_vendor_contacts pvc,FND_USER f
588: where pvc.PER_PARTY_ID= f.person_party_id
589: AND pvc.vendor_contact_id=p_contact_id;
590:
591: CURSOR cur_cust_user(p_contact_id IN NUMBER,p_object_id IN number) IS

Line 595: FND_USER f

591: CURSOR cur_cust_user(p_contact_id IN NUMBER,p_object_id IN number) IS
592: SELECT f.user_name ,( hz.person_first_name||' '||hz.person_last_name ) contact_name FROM
593: hz_relationships hr,
594: hz_parties hz,
595: FND_USER f
596: WHERE
597: hr.party_id = p_contact_id
598: AND hr.subject_id = hz.party_id
599: AND hr.object_id = p_object_id

Line 614: fnd_user f

610:
611: CURSOR cur_int_user(p_contact_id IN NUMBER) is
612: SELECT f.user_name,p.full_name contact_name from
613: per_workforce_v p,
614: fnd_user f
615: WHERE f.employee_id(+)=p.person_id and
616: p.person_id=p_contact_id;
617:
618: l_user_name VARCHAR2(40);

Line 3268: l_user_id FND_USER.USER_ID%TYPE;

3264:
3265: l_api_version CONSTANT NUMBER := 1;
3266: l_api_name CONSTANT VARCHAR2(30) := 'insert_deliverables_qa_checks';
3267: l_okc_doc_qa_lists_tbl okc_doc_qa_lists_tbl_type;
3268: l_user_id FND_USER.USER_ID%TYPE;
3269:
3270: BEGIN
3271:
3272: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN