DBA Data[Home] [Help]

APPS.PAY_KW_CHEQUE_REPORT dependencies on PER_JOBS

Line 216: FROM per_jobs

212:
213: /* Cursor for fetching the job name */
214: CURSOR csr_job (l_job number, l_date date) IS
215: SELECT name
216: FROM per_jobs
217: WHERE job_id = l_job
218: AND trunc(l_date,'MM') between date_from and nvl(date_to, to_date('31/12/4712','DD/MM/YYYY'));
219:
220: /* Cursor for fetching the Organization name */