DBA Data[Home] [Help]

APPS.PAY_SA_CHEQUE_REPORT dependencies on PER_JOBS

Line 187: FROM per_jobs

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