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 6326: PER_JOBS_VL

6322: name
6323: INTO
6324: PO_COMMUNICATION_PVT.g_job_name
6325: FROM
6326: PER_JOBS_VL
6327: WHERE
6328: job_id = p_job_id;
6329: end if;
6330: