APPS.PO_PDOI_POSTPROC_PVT dependencies on PER_WORKFORCE_CURRENT_X

Line 3543: l_current_employee_id per_workforce_current_x.person_id%TYPE :=NULL; --Bug 13627272

3539: l_email_flag VARCHAR2(1) := 'N';
3540: l_fax_flag VARCHAR2(1) := 'N';
3541: l_print_flag VARCHAR2(1) := 'N';
3542:
3543: l_current_employee_id per_workforce_current_x.person_id%TYPE :=NULL; --Bug 13627272
3544: BEGIN
3545: d_position := 0;
3546: IF (PO_LOG.d_proc) THEN
3547: PO_LOG.proc_begin(d_module);

Line 3604: per_workforce_current_x emp,

3600: BEGIN
3601: SELECT emp.person_id
3602: INTO l_current_employee_id
3603: FROM fnd_user fu,
3604: per_workforce_current_x emp,
3605: po_agents poa
3606: WHERE fu.user_id = fnd_global.user_id
3607: AND fu.employee_id = emp.person_id (+)
3608: AND emp.person_id = poa.agent_id (+)