eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_FULL_SYNC_MESSAGES dependencies on PER_JOBS

Line 55: TYPE setidType IS TABLE OF per_jobs.business_group_id%type INDEX BY BINARY_INTEGER;

51: WorkForcedeltaType WorkForceTblType;
52:
53:
54:
55: TYPE setidType IS TABLE OF per_jobs.business_group_id%type INDEX BY BINARY_INTEGER;
56: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;
57: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;
58: TYPE effstatusType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
59: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;

Line 56: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;

52:
53:
54:
55: TYPE setidType IS TABLE OF per_jobs.business_group_id%type INDEX BY BINARY_INTEGER;
56: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;
57: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;
58: TYPE effstatusType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
59: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;
60: TYPE jobcode IS REF CURSOR;

Line 57: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;

53:
54:
55: TYPE setidType IS TABLE OF per_jobs.business_group_id%type INDEX BY BINARY_INTEGER;
56: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;
57: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;
58: TYPE effstatusType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
59: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;
60: TYPE jobcode IS REF CURSOR;
61:

Line 59: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;

55: TYPE setidType IS TABLE OF per_jobs.business_group_id%type INDEX BY BINARY_INTEGER;
56: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;
57: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;
58: TYPE effstatusType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
59: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;
60: TYPE jobcode IS REF CURSOR;
61:
62: TYPE JobCodeTblType IS RECORD
63: (

Line 670: FROM PER_JOBS

666: JOB_ID JOBCODE,
667: DATE_FROM EFFDT,
668: DECODE(DATE_TO,NULL,'ACTIVE','INACTIVE') EFF_STATUS,
669: NAME DESCR
670: FROM PER_JOBS
671: WHERE last_update_date <= p_eff_date;
672:
673: LOOP
674: BEGIN