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 492: -- FROM PA_SCHEDULES_V sch

488: -- assignment_id,project_id,schedule_type_code,status_code,
489: -- system_status_code,start_date,end_date,Monday_hours,Tuesday_hours,
490: -- Wednesday_hours,Thursday_hours,
491: -- Friday_hours,Saturday_hours,Sunday_hours
492: -- FROM PA_SCHEDULES_V sch
493: -- WHERE sch.assignment_id = p_assignment_id
494: -- AND sch.schedule_type_code IN
495: -- ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
496: -- AND ( ( p_start_date BETWEEN sch.start_date AND sch.end_date)

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

499: -- ORDER BY start_date;
500:
501: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
502:
503: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
504: INDEX BY BINARY_INTEGER;
505: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
506: INDEX BY BINARY_INTEGER;
507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

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

501: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
502:
503: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
504: INDEX BY BINARY_INTEGER;
505: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
506: INDEX BY BINARY_INTEGER;
507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
508: INDEX BY BINARY_INTEGER;
509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

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

503: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
504: INDEX BY BINARY_INTEGER;
505: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
506: INDEX BY BINARY_INTEGER;
507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
508: INDEX BY BINARY_INTEGER;
509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
510: INDEX BY BINARY_INTEGER;
511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

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

505: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
506: INDEX BY BINARY_INTEGER;
507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
508: INDEX BY BINARY_INTEGER;
509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
510: INDEX BY BINARY_INTEGER;
511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
512: INDEX BY BINARY_INTEGER;
513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

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

507: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
508: INDEX BY BINARY_INTEGER;
509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
510: INDEX BY BINARY_INTEGER;
511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
512: INDEX BY BINARY_INTEGER;
513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
514: INDEX BY BINARY_INTEGER;
515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

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

509: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
510: INDEX BY BINARY_INTEGER;
511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
512: INDEX BY BINARY_INTEGER;
513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
514: INDEX BY BINARY_INTEGER;
515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
516: INDEX BY BINARY_INTEGER;
517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

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

511: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
512: INDEX BY BINARY_INTEGER;
513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
514: INDEX BY BINARY_INTEGER;
515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
516: INDEX BY BINARY_INTEGER;
517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
518: INDEX BY BINARY_INTEGER;
519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

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

513: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
514: INDEX BY BINARY_INTEGER;
515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
516: INDEX BY BINARY_INTEGER;
517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
518: INDEX BY BINARY_INTEGER;
519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
520: INDEX BY BINARY_INTEGER;
521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

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

515: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
516: INDEX BY BINARY_INTEGER;
517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
518: INDEX BY BINARY_INTEGER;
519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
520: INDEX BY BINARY_INTEGER;
521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
522: INDEX BY BINARY_INTEGER;
523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

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

517: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
518: INDEX BY BINARY_INTEGER;
519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
520: INDEX BY BINARY_INTEGER;
521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
522: INDEX BY BINARY_INTEGER;
523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
524: INDEX BY BINARY_INTEGER;
525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

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

519: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
520: INDEX BY BINARY_INTEGER;
521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
522: INDEX BY BINARY_INTEGER;
523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
524: INDEX BY BINARY_INTEGER;
525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
526: INDEX BY BINARY_INTEGER;
527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

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

521: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
522: INDEX BY BINARY_INTEGER;
523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
524: INDEX BY BINARY_INTEGER;
525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
526: INDEX BY BINARY_INTEGER;
527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
528: INDEX BY BINARY_INTEGER;
529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

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

523: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
524: INDEX BY BINARY_INTEGER;
525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
526: INDEX BY BINARY_INTEGER;
527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
528: INDEX BY BINARY_INTEGER;
529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
530: INDEX BY BINARY_INTEGER;
531: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

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

525: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
526: INDEX BY BINARY_INTEGER;
527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
528: INDEX BY BINARY_INTEGER;
529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
530: INDEX BY BINARY_INTEGER;
531: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
532: INDEX BY BINARY_INTEGER;
533: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

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

527: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
528: INDEX BY BINARY_INTEGER;
529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
530: INDEX BY BINARY_INTEGER;
531: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
532: INDEX BY BINARY_INTEGER;
533: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
534: INDEX BY BINARY_INTEGER;
535:

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

529: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
530: INDEX BY BINARY_INTEGER;
531: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
532: INDEX BY BINARY_INTEGER;
533: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
534: INDEX BY BINARY_INTEGER;
535:
536: l_schedule_id_tbl schedule_id_tbl ;
537: l_calendar_id_tbl calendar_id_tbl ;

Line 639: FROM PA_SCHEDULES_V sch

635: l_Thursday_hours_tbl,
636: l_Friday_hours_tbl,
637: l_Saturday_hours_tbl,
638: l_Sunday_hours_tbl
639: FROM PA_SCHEDULES_V sch
640: WHERE sch.assignment_id = p_assignment_id
641: AND sch.schedule_type_code IN
642: ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
643: AND ( ( p_start_date BETWEEN sch.start_date AND sch.end_date)

Line 912: -- FROM PA_SCHEDULES_V sch

908: -- assignment_id,project_id,schedule_type_code,status_code,
909: -- system_status_code,start_date,end_date,Monday_hours,Tuesday_hours,Wednesday_hours,
910: -- Thursday_hours,
911: -- Friday_hours,Saturday_hours,Sunday_hours
912: -- FROM PA_SCHEDULES_V sch
913: -- WHERE sch.assignment_id = p_assignment_id
914: -- AND sch.schedule_type_code IN
915: -- ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
916: -- ORDER BY start_date;

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

916: -- ORDER BY start_date;
917:
918: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
919:
920: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
921: INDEX BY BINARY_INTEGER;
922: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
923: INDEX BY BINARY_INTEGER;
924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE

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

918: /* Bug - 1846658- Following lines are added to incorporate the BULK SELECT to enhance the performance*/
919:
920: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
921: INDEX BY BINARY_INTEGER;
922: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
923: INDEX BY BINARY_INTEGER;
924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
925: INDEX BY BINARY_INTEGER;
926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE

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

920: TYPE schedule_id_tbl IS TABLE OF PA_SCHEDULES_V.schedule_id%TYPE
921: INDEX BY BINARY_INTEGER;
922: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
923: INDEX BY BINARY_INTEGER;
924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
925: INDEX BY BINARY_INTEGER;
926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
927: INDEX BY BINARY_INTEGER;
928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE

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

922: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES_V.calendar_id%TYPE
923: INDEX BY BINARY_INTEGER;
924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
925: INDEX BY BINARY_INTEGER;
926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
927: INDEX BY BINARY_INTEGER;
928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
929: INDEX BY BINARY_INTEGER;
930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE

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

924: TYPE assignment_id_tbl IS TABLE OF PA_SCHEDULES_V.assignment_id%TYPE
925: INDEX BY BINARY_INTEGER;
926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
927: INDEX BY BINARY_INTEGER;
928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
929: INDEX BY BINARY_INTEGER;
930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
931: INDEX BY BINARY_INTEGER;
932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE

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

926: TYPE project_id_tbl IS TABLE OF PA_SCHEDULES_V.project_id%TYPE
927: INDEX BY BINARY_INTEGER;
928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
929: INDEX BY BINARY_INTEGER;
930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
931: INDEX BY BINARY_INTEGER;
932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
933: INDEX BY BINARY_INTEGER;
934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE

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

928: TYPE schedule_type_code_tbl IS TABLE OF PA_SCHEDULES_V.schedule_type_code%TYPE
929: INDEX BY BINARY_INTEGER;
930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
931: INDEX BY BINARY_INTEGER;
932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
933: INDEX BY BINARY_INTEGER;
934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
935: INDEX BY BINARY_INTEGER;
936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE

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

930: TYPE status_code_tbl IS TABLE OF PA_SCHEDULES_V.status_code%TYPE
931: INDEX BY BINARY_INTEGER;
932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
933: INDEX BY BINARY_INTEGER;
934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
935: INDEX BY BINARY_INTEGER;
936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
937: INDEX BY BINARY_INTEGER;
938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE

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

932: TYPE system_status_code_tbl IS TABLE OF PA_SCHEDULES_V.system_status_code%TYPE
933: INDEX BY BINARY_INTEGER;
934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
935: INDEX BY BINARY_INTEGER;
936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
937: INDEX BY BINARY_INTEGER;
938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
939: INDEX BY BINARY_INTEGER;
940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE

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

934: TYPE start_date_tbl IS TABLE OF PA_SCHEDULES_V.start_date%TYPE
935: INDEX BY BINARY_INTEGER;
936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
937: INDEX BY BINARY_INTEGER;
938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
939: INDEX BY BINARY_INTEGER;
940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
941: INDEX BY BINARY_INTEGER;
942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE

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

936: TYPE end_date_tbl IS TABLE OF PA_SCHEDULES_V.end_date%TYPE
937: INDEX BY BINARY_INTEGER;
938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
939: INDEX BY BINARY_INTEGER;
940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
941: INDEX BY BINARY_INTEGER;
942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
943: INDEX BY BINARY_INTEGER;
944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE

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

938: TYPE Monday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Monday_hours%TYPE
939: INDEX BY BINARY_INTEGER;
940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
941: INDEX BY BINARY_INTEGER;
942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
943: INDEX BY BINARY_INTEGER;
944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
945: INDEX BY BINARY_INTEGER;
946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE

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

940: TYPE Tuesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Tuesday_hours%TYPE
941: INDEX BY BINARY_INTEGER;
942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
943: INDEX BY BINARY_INTEGER;
944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
945: INDEX BY BINARY_INTEGER;
946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
947: INDEX BY BINARY_INTEGER;
948: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE

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

942: TYPE Wednesday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Wednesday_hours%TYPE
943: INDEX BY BINARY_INTEGER;
944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
945: INDEX BY BINARY_INTEGER;
946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
947: INDEX BY BINARY_INTEGER;
948: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
949: INDEX BY BINARY_INTEGER;
950: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE

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

944: TYPE Thursday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Thursday_hours%TYPE
945: INDEX BY BINARY_INTEGER;
946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
947: INDEX BY BINARY_INTEGER;
948: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
949: INDEX BY BINARY_INTEGER;
950: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
951: INDEX BY BINARY_INTEGER;
952:

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

946: TYPE Friday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Friday_hours%TYPE
947: INDEX BY BINARY_INTEGER;
948: TYPE Saturday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Saturday_hours%TYPE
949: INDEX BY BINARY_INTEGER;
950: TYPE Sunday_hours_tbl IS TABLE OF PA_SCHEDULES_V.Sunday_hours%TYPE
951: INDEX BY BINARY_INTEGER;
952:
953: l_schedule_id_tbl schedule_id_tbl ;
954: l_calendar_id_tbl calendar_id_tbl ;

Line 1037: FROM PA_SCHEDULES_V sch

1033: l_Thursday_hours_tbl,
1034: l_Friday_hours_tbl,
1035: l_Saturday_hours_tbl,
1036: l_Sunday_hours_tbl
1037: FROM PA_SCHEDULES_V sch
1038: WHERE sch.assignment_id = p_assignment_id
1039: AND sch.schedule_type_code IN ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT', 'STAFFED_ADMIN_ASSIGNMENT')
1040: ORDER BY start_date;
1041: