APPS.PER_PERRPREQ_XMLP_PKG dependencies on PER_JOBS

Line 41: L_JOB PER_JOBS.NAME%TYPE;

37: RETURN L_ORG_NAME;
38: END GET_ORGANIZATION;
39:
40: FUNCTION GET_JOB RETURN VARCHAR2 IS
41: L_JOB PER_JOBS.NAME%TYPE;
42: BEGIN
43: IF P_JOB_ID IS NOT NULL THEN
44: SELECT NAME
45: INTO L_JOB

Line 46: FROM PER_JOBS_VL

42: BEGIN
43: IF P_JOB_ID IS NOT NULL THEN
44: SELECT NAME
45: INTO L_JOB
46: FROM PER_JOBS_VL
47: WHERE JOB_ID = P_JOB_ID;
48: END IF;
49: RETURN L_JOB;
50: END GET_JOB;