DBA Data[Home] [Help]

APPS.PA_PAXPEAST_XMLP_PKG dependencies on PER_JOBS

Line 25: Job_Name per_jobs.name%TYPE;

21: begin
22: declare
23: init_error exception;
24: Org_Name hr_organization_units.name%TYPE;
25: Job_Name per_jobs.name%TYPE;
26: Sort_By_Meaning pa_lookups.meaning%TYPE;
27: begin
28: ORGANIZATION_ID_T:=ORGANIZATION_ID;
29: JOB_ID_T := JOB_ID;

Line 39: select name into Job_Name from per_jobs

35: organization_id = ORGANIZATION_ID_T;
36: end if;
37: C_Org_Name := Org_Name;
38: if Job_id is not NULL then
39: select name into Job_Name from per_jobs
40: where
41: job_id = JOB_ID_T;
42: end if;
43: C_Job := Job_Name;