APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on PER_JOBS

Line 413: from per_jobs

409: -- Get the total count if "Last" hyperlink is clicked
410: IF (p_range_high < 0) THEN
411: SELECT count(*)
412: INTO l_total_count
413: from per_jobs
414: where UPPER(name) like l_display_value
415: and sysdate >= date_from and sysdate <= NVL(date_to, sysdate);
416:
417: l_start := MOD(l_total_count, l_rec_set);

Line 431: from per_jobs

427: END IF;
428:
429: OPEN lov_output_cur FOR
430: select name, to_char(job_id), to_char(business_group_id), null, null, null, null, null, null, null
431: from per_jobs
432: where UPPER(name) like l_display_value
433: and sysdate >= date_from and sysdate <= NVL(date_to, sysdate)
434: order by name;
435: else

Line 441: from per_jobs

437: -- Get the total count if "Last" hyperlink is clicked
438: IF (p_range_high < 0) THEN
439: SELECT count(*)
440: INTO l_total_count
441: from per_jobs
442: where UPPER(name) like l_display_value
443: and business_group_id = l_aux_value1
444: and sysdate >= date_from and sysdate <= NVL(date_to, sysdate) ;
445:

Line 461: from per_jobs

457:
458: OPEN lov_output_cur FOR
459:
460: select name, to_char(job_id), to_char(business_group_id), null, null, null, null, null, null, null
461: from per_jobs
462: where UPPER(name) like NVL(l_display_value, '%')
463: and business_group_id = l_aux_value1
464: and sysdate >= date_from and sysdate <= NVL(date_to, sysdate)
465: order by name;