DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on PER_JOBS_VL

Line 73: g_job_name PER_JOBS_VL.name%type := null;

69: g_vendor_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;
70: g_vendor_city_state_zipInfo varchar2(500) := null;
71: g_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type := null;
72: g_job_id PO_LINES_ALL.JOB_ID%type := null;
73: g_job_name PER_JOBS_VL.name%type := null;
74: g_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
75: --Bug 4504228 START
76: g_person_id PER_ALL_PEOPLE_F.PERSON_ID%type := null;
77: g_buyer_email_address PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type := null;

Line 7436: PER_JOBS_VL

7432: name
7433: INTO
7434: PO_COMMUNICATION_PVT.g_job_name
7435: FROM
7436: PER_JOBS_VL
7437: WHERE
7438: job_id = p_job_id;
7439: end if;
7440: