APPS.PO_DOC_NUMBERING_PKG dependencies on FND_USER

Line 2258: FROM per_people_extra_info pei, fnd_user fu

2254:
2255: BEGIN
2256: SELECT PEI_INFORMATION2
2257: INTO x_dodaac
2258: FROM per_people_extra_info pei, fnd_user fu
2259: WHERE pei.information_type = 'CLM_CONTACT_TITLE'
2260: AND pei.person_id= fu.employee_id
2261: AND fu.user_id = fnd_global.user_id;
2262: EXCEPTION

Line 2811: FROM per_people_extra_info pei, fnd_user fu

2807: -- Do the defaulting for attributes and set the document number
2808: BEGIN
2809: SELECT PEI_INFORMATION2
2810: INTO x_dodaac
2811: FROM per_people_extra_info pei, fnd_user fu
2812: WHERE pei.information_type = 'CLM_CONTACT_TITLE'
2813: AND pei.person_id= fu.employee_id
2814: AND fu.user_id = fnd_global.user_id;
2815: EXCEPTION

Line 3854: FROM per_people_extra_info pei, fnd_user fu

3850: x_source_doc_number := p_source_doc_number;
3851: BEGIN
3852: SELECT PEI_INFORMATION3
3853: INTO x_call_order_number
3854: FROM per_people_extra_info pei, fnd_user fu
3855: WHERE pei.information_type = 'CLM_CONTACT_TITLE'
3856: AND pei.person_id= fu.employee_id
3857: AND fu.user_id = fnd_global.user_id;
3858: EXCEPTION

Line 5192: FROM per_people_extra_info pei, fnd_user fu

5188: --Get user's default DoDAAC
5189: BEGIN
5190: SELECT PEI_INFORMATION2
5191: INTO l_user_def_dodaac
5192: FROM per_people_extra_info pei, fnd_user fu
5193: WHERE pei.information_type = 'CLM_CONTACT_TITLE'
5194: AND pei.person_id= fu.employee_id
5195: AND fu.user_id = fnd_global.user_id;
5196: EXCEPTION