APPS.PER_QH_SUMMARY_QUERY dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 701: ,ea1_attended_start_date per_establishment_attendances.attended_start_date%type

697: ,tax_field148 DATE
698: ,tax_field149 DATE
699: ,tax_field150 DATE
700: -- Bug 3357807 End Here
701: ,ea1_attended_start_date per_establishment_attendances.attended_start_date%type
702: ,ea1_full_time per_establishment_attendances.full_time%type
703: ,ea1_attended_end_date per_establishment_attendances.attended_end_date%type
704: ,ea1_establishment per_establishments.name%type
705: ,ea2_attended_start_date per_establishment_attendances.attended_start_date%type

Line 702: ,ea1_full_time per_establishment_attendances.full_time%type

698: ,tax_field149 DATE
699: ,tax_field150 DATE
700: -- Bug 3357807 End Here
701: ,ea1_attended_start_date per_establishment_attendances.attended_start_date%type
702: ,ea1_full_time per_establishment_attendances.full_time%type
703: ,ea1_attended_end_date per_establishment_attendances.attended_end_date%type
704: ,ea1_establishment per_establishments.name%type
705: ,ea2_attended_start_date per_establishment_attendances.attended_start_date%type
706: ,ea2_full_time per_establishment_attendances.full_time%type

Line 703: ,ea1_attended_end_date per_establishment_attendances.attended_end_date%type

699: ,tax_field150 DATE
700: -- Bug 3357807 End Here
701: ,ea1_attended_start_date per_establishment_attendances.attended_start_date%type
702: ,ea1_full_time per_establishment_attendances.full_time%type
703: ,ea1_attended_end_date per_establishment_attendances.attended_end_date%type
704: ,ea1_establishment per_establishments.name%type
705: ,ea2_attended_start_date per_establishment_attendances.attended_start_date%type
706: ,ea2_full_time per_establishment_attendances.full_time%type
707: ,ea2_attended_end_date per_establishment_attendances.attended_end_date%type

Line 705: ,ea2_attended_start_date per_establishment_attendances.attended_start_date%type

701: ,ea1_attended_start_date per_establishment_attendances.attended_start_date%type
702: ,ea1_full_time per_establishment_attendances.full_time%type
703: ,ea1_attended_end_date per_establishment_attendances.attended_end_date%type
704: ,ea1_establishment per_establishments.name%type
705: ,ea2_attended_start_date per_establishment_attendances.attended_start_date%type
706: ,ea2_full_time per_establishment_attendances.full_time%type
707: ,ea2_attended_end_date per_establishment_attendances.attended_end_date%type
708: ,ea2_establishment per_establishments.name%type
709: ,ea3_attended_start_date per_establishment_attendances.attended_start_date%type

Line 706: ,ea2_full_time per_establishment_attendances.full_time%type

702: ,ea1_full_time per_establishment_attendances.full_time%type
703: ,ea1_attended_end_date per_establishment_attendances.attended_end_date%type
704: ,ea1_establishment per_establishments.name%type
705: ,ea2_attended_start_date per_establishment_attendances.attended_start_date%type
706: ,ea2_full_time per_establishment_attendances.full_time%type
707: ,ea2_attended_end_date per_establishment_attendances.attended_end_date%type
708: ,ea2_establishment per_establishments.name%type
709: ,ea3_attended_start_date per_establishment_attendances.attended_start_date%type
710: ,ea3_full_time per_establishment_attendances.full_time%type

Line 707: ,ea2_attended_end_date per_establishment_attendances.attended_end_date%type

703: ,ea1_attended_end_date per_establishment_attendances.attended_end_date%type
704: ,ea1_establishment per_establishments.name%type
705: ,ea2_attended_start_date per_establishment_attendances.attended_start_date%type
706: ,ea2_full_time per_establishment_attendances.full_time%type
707: ,ea2_attended_end_date per_establishment_attendances.attended_end_date%type
708: ,ea2_establishment per_establishments.name%type
709: ,ea3_attended_start_date per_establishment_attendances.attended_start_date%type
710: ,ea3_full_time per_establishment_attendances.full_time%type
711: ,ea3_attended_end_date per_establishment_attendances.attended_end_date%type

Line 709: ,ea3_attended_start_date per_establishment_attendances.attended_start_date%type

705: ,ea2_attended_start_date per_establishment_attendances.attended_start_date%type
706: ,ea2_full_time per_establishment_attendances.full_time%type
707: ,ea2_attended_end_date per_establishment_attendances.attended_end_date%type
708: ,ea2_establishment per_establishments.name%type
709: ,ea3_attended_start_date per_establishment_attendances.attended_start_date%type
710: ,ea3_full_time per_establishment_attendances.full_time%type
711: ,ea3_attended_end_date per_establishment_attendances.attended_end_date%type
712: ,ea3_establishment per_establishments.name%type
713: ,ea4_attended_start_date per_establishment_attendances.attended_start_date%type

Line 710: ,ea3_full_time per_establishment_attendances.full_time%type

706: ,ea2_full_time per_establishment_attendances.full_time%type
707: ,ea2_attended_end_date per_establishment_attendances.attended_end_date%type
708: ,ea2_establishment per_establishments.name%type
709: ,ea3_attended_start_date per_establishment_attendances.attended_start_date%type
710: ,ea3_full_time per_establishment_attendances.full_time%type
711: ,ea3_attended_end_date per_establishment_attendances.attended_end_date%type
712: ,ea3_establishment per_establishments.name%type
713: ,ea4_attended_start_date per_establishment_attendances.attended_start_date%type
714: ,ea4_full_time per_establishment_attendances.full_time%type

Line 711: ,ea3_attended_end_date per_establishment_attendances.attended_end_date%type

707: ,ea2_attended_end_date per_establishment_attendances.attended_end_date%type
708: ,ea2_establishment per_establishments.name%type
709: ,ea3_attended_start_date per_establishment_attendances.attended_start_date%type
710: ,ea3_full_time per_establishment_attendances.full_time%type
711: ,ea3_attended_end_date per_establishment_attendances.attended_end_date%type
712: ,ea3_establishment per_establishments.name%type
713: ,ea4_attended_start_date per_establishment_attendances.attended_start_date%type
714: ,ea4_full_time per_establishment_attendances.full_time%type
715: ,ea4_attended_end_date per_establishment_attendances.attended_end_date%type

Line 713: ,ea4_attended_start_date per_establishment_attendances.attended_start_date%type

709: ,ea3_attended_start_date per_establishment_attendances.attended_start_date%type
710: ,ea3_full_time per_establishment_attendances.full_time%type
711: ,ea3_attended_end_date per_establishment_attendances.attended_end_date%type
712: ,ea3_establishment per_establishments.name%type
713: ,ea4_attended_start_date per_establishment_attendances.attended_start_date%type
714: ,ea4_full_time per_establishment_attendances.full_time%type
715: ,ea4_attended_end_date per_establishment_attendances.attended_end_date%type
716: ,ea4_establishment per_establishments.name%type
717: );

Line 714: ,ea4_full_time per_establishment_attendances.full_time%type

710: ,ea3_full_time per_establishment_attendances.full_time%type
711: ,ea3_attended_end_date per_establishment_attendances.attended_end_date%type
712: ,ea3_establishment per_establishments.name%type
713: ,ea4_attended_start_date per_establishment_attendances.attended_start_date%type
714: ,ea4_full_time per_establishment_attendances.full_time%type
715: ,ea4_attended_end_date per_establishment_attendances.attended_end_date%type
716: ,ea4_establishment per_establishments.name%type
717: );
718:

Line 715: ,ea4_attended_end_date per_establishment_attendances.attended_end_date%type

711: ,ea3_attended_end_date per_establishment_attendances.attended_end_date%type
712: ,ea3_establishment per_establishments.name%type
713: ,ea4_attended_start_date per_establishment_attendances.attended_start_date%type
714: ,ea4_full_time per_establishment_attendances.full_time%type
715: ,ea4_attended_end_date per_establishment_attendances.attended_end_date%type
716: ,ea4_establishment per_establishments.name%type
717: );
718:
719: type sumtab is table of sumrec