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.PA_SCHEDULE_PVT dependencies on PA_SCHEDULES_V

Line 322: -- FROM PA_SCHEDULES_V sch

318: -- assignment_id,project_id,schedule_type_code,status_code,
319: -- system_status_code,start_date,end_date,Monday_hours,Tuesday_hours,
320: -- Wednesday_hours,Thursday_hours,
321: -- Friday_hours,Saturday_hours,Sunday_hours
322: -- FROM PA_SCHEDULES_V sch
323: -- WHERE sch.assignment_id = p_assignment_id
324: -- AND sch.schedule_type_code IN
325: -- ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
326: -- AND ( ( p_start_date BETWEEN sch.start_date AND sch.end_date)

Line 333: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE

329: -- ORDER BY start_date;
330:
331: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
332:
333: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
334: INDEX BY BINARY_INTEGER;
335: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
336: INDEX BY BINARY_INTEGER;
337: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

Line 335: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE

331: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
332:
333: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
334: INDEX BY BINARY_INTEGER;
335: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
336: INDEX BY BINARY_INTEGER;
337: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
338: INDEX BY BINARY_INTEGER;
339: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

Line 337: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

333: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
334: INDEX BY BINARY_INTEGER;
335: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
336: INDEX BY BINARY_INTEGER;
337: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
338: INDEX BY BINARY_INTEGER;
339: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
340: INDEX BY BINARY_INTEGER;
341: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

Line 339: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

335: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
336: INDEX BY BINARY_INTEGER;
337: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
338: INDEX BY BINARY_INTEGER;
339: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
340: INDEX BY BINARY_INTEGER;
341: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
342: INDEX BY BINARY_INTEGER;
343: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

Line 341: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

337: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
338: INDEX BY BINARY_INTEGER;
339: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
340: INDEX BY BINARY_INTEGER;
341: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
342: INDEX BY BINARY_INTEGER;
343: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
344: INDEX BY BINARY_INTEGER;
345: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

Line 343: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

339: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
340: INDEX BY BINARY_INTEGER;
341: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
342: INDEX BY BINARY_INTEGER;
343: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
344: INDEX BY BINARY_INTEGER;
345: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
346: INDEX BY BINARY_INTEGER;
347: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

Line 345: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

341: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
342: INDEX BY BINARY_INTEGER;
343: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
344: INDEX BY BINARY_INTEGER;
345: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
346: INDEX BY BINARY_INTEGER;
347: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
348: INDEX BY BINARY_INTEGER;
349: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

Line 347: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

343: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
344: INDEX BY BINARY_INTEGER;
345: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
346: INDEX BY BINARY_INTEGER;
347: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
348: INDEX BY BINARY_INTEGER;
349: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
350: INDEX BY BINARY_INTEGER;
351: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

Line 349: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

345: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
346: INDEX BY BINARY_INTEGER;
347: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
348: INDEX BY BINARY_INTEGER;
349: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
350: INDEX BY BINARY_INTEGER;
351: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
352: INDEX BY BINARY_INTEGER;
353: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

Line 351: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

347: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
348: INDEX BY BINARY_INTEGER;
349: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
350: INDEX BY BINARY_INTEGER;
351: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
352: INDEX BY BINARY_INTEGER;
353: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
354: INDEX BY BINARY_INTEGER;
355: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

Line 353: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

349: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
350: INDEX BY BINARY_INTEGER;
351: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
352: INDEX BY BINARY_INTEGER;
353: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
354: INDEX BY BINARY_INTEGER;
355: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
356: INDEX BY BINARY_INTEGER;
357: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

Line 355: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

351: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
352: INDEX BY BINARY_INTEGER;
353: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
354: INDEX BY BINARY_INTEGER;
355: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
356: INDEX BY BINARY_INTEGER;
357: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
358: INDEX BY BINARY_INTEGER;
359: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

Line 357: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

353: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
354: INDEX BY BINARY_INTEGER;
355: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
356: INDEX BY BINARY_INTEGER;
357: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
358: INDEX BY BINARY_INTEGER;
359: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
360: INDEX BY BINARY_INTEGER;
361: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

Line 359: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

355: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
356: INDEX BY BINARY_INTEGER;
357: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
358: INDEX BY BINARY_INTEGER;
359: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
360: INDEX BY BINARY_INTEGER;
361: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
362: INDEX BY BINARY_INTEGER;
363: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

Line 361: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

357: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
358: INDEX BY BINARY_INTEGER;
359: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
360: INDEX BY BINARY_INTEGER;
361: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
362: INDEX BY BINARY_INTEGER;
363: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
364: INDEX BY BINARY_INTEGER;
365:

Line 363: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

359: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
360: INDEX BY BINARY_INTEGER;
361: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
362: INDEX BY BINARY_INTEGER;
363: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
364: INDEX BY BINARY_INTEGER;
365:
366: l_schedule_id_tbl schedule_id_tbl ;
367: l_calendar_id_tbl calendar_id_tbl ;

Line 469: FROM PA_SCHEDULES_V sch

465: l_Thursday_hours_tbl,
466: l_Friday_hours_tbl,
467: l_Saturday_hours_tbl,
468: l_Sunday_hours_tbl
469: FROM PA_SCHEDULES_V sch
470: WHERE sch.assignment_id = p_assignment_id
471: AND sch.schedule_type_code IN
472: ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
473: AND ( ( p_start_date BETWEEN sch.start_date AND sch.end_date)

Line 742: -- FROM PA_SCHEDULES_V sch

738: -- assignment_id,project_id,schedule_type_code,status_code,
739: -- system_status_code,start_date,end_date,Monday_hours,Tuesday_hours,Wednesday_hours,
740: -- Thursday_hours,
741: -- Friday_hours,Saturday_hours,Sunday_hours
742: -- FROM PA_SCHEDULES_V sch
743: -- WHERE sch.assignment_id = p_assignment_id
744: -- AND sch.schedule_type_code IN
745: -- ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
746: -- ORDER BY start_date;

Line 750: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE

746: -- ORDER BY start_date;
747:
748: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
749:
750: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
751: INDEX BY BINARY_INTEGER;
752: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
753: INDEX BY BINARY_INTEGER;
754: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

Line 752: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE

748: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
749:
750: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
751: INDEX BY BINARY_INTEGER;
752: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
753: INDEX BY BINARY_INTEGER;
754: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
755: INDEX BY BINARY_INTEGER;
756: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

Line 754: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

750: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
751: INDEX BY BINARY_INTEGER;
752: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
753: INDEX BY BINARY_INTEGER;
754: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
755: INDEX BY BINARY_INTEGER;
756: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
757: INDEX BY BINARY_INTEGER;
758: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

Line 756: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

752: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
753: INDEX BY BINARY_INTEGER;
754: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
755: INDEX BY BINARY_INTEGER;
756: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
757: INDEX BY BINARY_INTEGER;
758: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
759: INDEX BY BINARY_INTEGER;
760: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

Line 758: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

754: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
755: INDEX BY BINARY_INTEGER;
756: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
757: INDEX BY BINARY_INTEGER;
758: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
759: INDEX BY BINARY_INTEGER;
760: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
761: INDEX BY BINARY_INTEGER;
762: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

Line 760: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

756: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
757: INDEX BY BINARY_INTEGER;
758: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
759: INDEX BY BINARY_INTEGER;
760: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
761: INDEX BY BINARY_INTEGER;
762: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
763: INDEX BY BINARY_INTEGER;
764: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

Line 762: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

758: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
759: INDEX BY BINARY_INTEGER;
760: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
761: INDEX BY BINARY_INTEGER;
762: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
763: INDEX BY BINARY_INTEGER;
764: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
765: INDEX BY BINARY_INTEGER;
766: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

Line 764: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

760: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
761: INDEX BY BINARY_INTEGER;
762: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
763: INDEX BY BINARY_INTEGER;
764: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
765: INDEX BY BINARY_INTEGER;
766: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
767: INDEX BY BINARY_INTEGER;
768: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

Line 766: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

762: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
763: INDEX BY BINARY_INTEGER;
764: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
765: INDEX BY BINARY_INTEGER;
766: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
767: INDEX BY BINARY_INTEGER;
768: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
769: INDEX BY BINARY_INTEGER;
770: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

Line 768: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

764: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
765: INDEX BY BINARY_INTEGER;
766: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
767: INDEX BY BINARY_INTEGER;
768: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
769: INDEX BY BINARY_INTEGER;
770: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
771: INDEX BY BINARY_INTEGER;
772: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

Line 770: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

766: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
767: INDEX BY BINARY_INTEGER;
768: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
769: INDEX BY BINARY_INTEGER;
770: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
771: INDEX BY BINARY_INTEGER;
772: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
773: INDEX BY BINARY_INTEGER;
774: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

Line 772: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

768: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
769: INDEX BY BINARY_INTEGER;
770: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
771: INDEX BY BINARY_INTEGER;
772: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
773: INDEX BY BINARY_INTEGER;
774: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
775: INDEX BY BINARY_INTEGER;
776: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

Line 774: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

770: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
771: INDEX BY BINARY_INTEGER;
772: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
773: INDEX BY BINARY_INTEGER;
774: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
775: INDEX BY BINARY_INTEGER;
776: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
777: INDEX BY BINARY_INTEGER;
778: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

Line 776: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

772: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
773: INDEX BY BINARY_INTEGER;
774: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
775: INDEX BY BINARY_INTEGER;
776: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
777: INDEX BY BINARY_INTEGER;
778: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
779: INDEX BY BINARY_INTEGER;
780: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

Line 778: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

774: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
775: INDEX BY BINARY_INTEGER;
776: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
777: INDEX BY BINARY_INTEGER;
778: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
779: INDEX BY BINARY_INTEGER;
780: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
781: INDEX BY BINARY_INTEGER;
782:

Line 780: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

776: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
777: INDEX BY BINARY_INTEGER;
778: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
779: INDEX BY BINARY_INTEGER;
780: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
781: INDEX BY BINARY_INTEGER;
782:
783: l_schedule_id_tbl schedule_id_tbl ;
784: l_calendar_id_tbl calendar_id_tbl ;

Line 867: FROM PA_SCHEDULES_V sch

863: l_Thursday_hours_tbl,
864: l_Friday_hours_tbl,
865: l_Saturday_hours_tbl,
866: l_Sunday_hours_tbl
867: FROM PA_SCHEDULES_V sch
868: WHERE sch.assignment_id = p_assignment_id
869: AND sch.schedule_type_code IN ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
870: ORDER BY start_date;
871: