DBA Data[Home] [Help]

APPS.PAY_AE_CHEQUE_REPORT dependencies on PER_JOBS

Line 183: FROM per_jobs

179: /* Cursor for fetching the job name */
180:
181: CURSOR csr_job (l_job number, l_date date) IS
182: SELECT name
183: FROM per_jobs
184: WHERE job_id = l_job
185: AND trunc(l_date,'MM') between date_from and nvl(date_to, to_date('31/12/4712','DD/MM/YYYY'));
186:
187: /* Cursor for fetching the Organization name */