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_DELTA_SYNC_MESSAGES dependencies on PER_JOBS

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

1822: ,retcode OUT NOCOPY VARCHAR2
1823: ,p_party_site_id in NUMBER)
1824: is
1825:
1826: TYPE setidType IS TABLE OF per_jobs.business_group_id%type INDEX BY BINARY_INTEGER;
1827: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;
1828: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;
1829: TYPE effstatusType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
1830: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;

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

1823: ,p_party_site_id in NUMBER)
1824: is
1825:
1826: TYPE setidType IS TABLE OF per_jobs.business_group_id%type INDEX BY BINARY_INTEGER;
1827: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;
1828: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;
1829: TYPE effstatusType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
1830: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;
1831: TYPE lstupddtType IS TABLE OF per_jobs.last_update_date%type INDEX BY BINARY_INTEGER;

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

1824: is
1825:
1826: TYPE setidType IS TABLE OF per_jobs.business_group_id%type INDEX BY BINARY_INTEGER;
1827: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;
1828: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;
1829: TYPE effstatusType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
1830: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;
1831: TYPE lstupddtType IS TABLE OF per_jobs.last_update_date%type INDEX BY BINARY_INTEGER;
1832: TYPE jobcode IS REF CURSOR;

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

1826: TYPE setidType IS TABLE OF per_jobs.business_group_id%type INDEX BY BINARY_INTEGER;
1827: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;
1828: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;
1829: TYPE effstatusType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
1830: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;
1831: TYPE lstupddtType IS TABLE OF per_jobs.last_update_date%type INDEX BY BINARY_INTEGER;
1832: TYPE jobcode IS REF CURSOR;
1833:
1834: TYPE JobCodeTblType IS RECORD

Line 1831: TYPE lstupddtType IS TABLE OF per_jobs.last_update_date%type INDEX BY BINARY_INTEGER;

1827: TYPE jobcodeType IS TABLE OF per_jobs.job_id%type INDEX BY BINARY_INTEGER;
1828: TYPE effdtType IS TABLE OF per_jobs.date_from%type INDEX BY BINARY_INTEGER;
1829: TYPE effstatusType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
1830: TYPE descrType IS TABLE OF per_jobs.name%type INDEX BY BINARY_INTEGER;
1831: TYPE lstupddtType IS TABLE OF per_jobs.last_update_date%type INDEX BY BINARY_INTEGER;
1832: TYPE jobcode IS REF CURSOR;
1833:
1834: TYPE JobCodeTblType IS RECORD
1835: (

Line 1940: FROM PER_JOBS

1936: DATE_FROM EFFDT,
1937: DECODE(DATE_TO,NULL,'ACTIVE','INACTIVE') EFF_STATUS,
1938: NAME DESCR,
1939: LAST_UPDATE_DATE LAST_UPD_DATE
1940: FROM PER_JOBS
1941: WHERE last_update_date >= p_lst_upddt
1942: AND BUSINESS_GROUP_ID = p_set_id
1943: AND JOB_ID = p_job_id;
1944:

Line 2020: FROM PER_JOBS job

2016: job.DATE_FROM EFFDT,
2017: DECODE(job.DATE_TO,NULL,'ACTIVE','INACTIVE') EFF_STATUS,
2018: job.NAME DESCR,
2019: job.LAST_UPDATE_DATE LAST_UPD_DATE
2020: FROM PER_JOBS job
2021: WHERE job.last_update_date >= run_date
2022: and (job.business_group_id,job.job_id)not in
2023: (select setid,jobcode from HR_JOBCODE_DELTA_SYNC jbcd
2024: where job.BUSINESS_GROUP_ID = jbcd.setid