754: ,ppf.LAST_NAME LAST_NAME
755: ,ppf.FIRST_NAME FIRST_NAME
756: ,hl.region_2 STATE
757: From
758: per_all_people_f ppf
759:
760: ,hr_locations_all hl
761: ,hr_soft_coding_keyflex hscf
762: ,per_all_assignments_f paf
809: ,ppf.LAST_NAME LAST_NAME
810: ,ppf.FIRST_NAME FIRST_NAME
811: ,hl.region_2 STATE
812: From
813: per_all_people_f ppf
814:
815: ,hr_locations_all hl
816: ,hr_soft_coding_keyflex hscf
817: ,per_all_assignments_f paf
1185: select
1186: count(ppf.person_id)
1187:
1188: From
1189: per_all_people_f ppf
1190: ,per_all_assignments_f paf
1191: ,hr_soft_coding_keyflex hscf
1192: ,hr_locations_all hl ,per_jobs job
1193: ,per_periods_of_service pps
1239: select
1240: count(ppf.person_id)
1241:
1242: From
1243: per_all_people_f ppf
1244: ,per_all_assignments_f paf
1245: ,hr_soft_coding_keyflex hscf
1246: ,hr_locations_all hl ,per_jobs job
1247: ,per_periods_of_service pps
1548: ,pps.date_start
1549: ,hl.region_2 STATE
1550:
1551: From
1552: per_all_people_f ppf
1553: ,per_all_assignments_f paf
1554: ,hr_soft_coding_keyflex hscf
1555: ,hr_locations_all hl ,per_jobs job
1556: ,per_periods_of_service pps
1595: ,pps.date_start
1596: ,hl.region_2 STATE
1597:
1598: From
1599: per_all_people_f ppf
1600: ,per_all_assignments_f paf
1601: ,hr_soft_coding_keyflex hscf
1602: ,hr_locations_all hl ,per_jobs job
1603: ,per_periods_of_service pps
1636: And ppf.per_information7 is NULL
1637: Order by 2,3;
1638:
1639:
1640: v_person_id per_all_people_f.person_id%TYPE;
1641: v_last_name per_all_people_f.last_name%TYPE;
1642: v_first_name per_all_people_f.first_name%TYPE;
1643: v_middle_name per_all_people_f.middle_names%TYPE;
1644: v_ssn per_all_people_f.national_identifier%TYPE;
1637: Order by 2,3;
1638:
1639:
1640: v_person_id per_all_people_f.person_id%TYPE;
1641: v_last_name per_all_people_f.last_name%TYPE;
1642: v_first_name per_all_people_f.first_name%TYPE;
1643: v_middle_name per_all_people_f.middle_names%TYPE;
1644: v_ssn per_all_people_f.national_identifier%TYPE;
1645: v_dob per_all_people_f.date_of_birth%TYPE;
1638:
1639:
1640: v_person_id per_all_people_f.person_id%TYPE;
1641: v_last_name per_all_people_f.last_name%TYPE;
1642: v_first_name per_all_people_f.first_name%TYPE;
1643: v_middle_name per_all_people_f.middle_names%TYPE;
1644: v_ssn per_all_people_f.national_identifier%TYPE;
1645: v_dob per_all_people_f.date_of_birth%TYPE;
1646: v_date_start per_periods_of_service.date_start%TYPE;
1639:
1640: v_person_id per_all_people_f.person_id%TYPE;
1641: v_last_name per_all_people_f.last_name%TYPE;
1642: v_first_name per_all_people_f.first_name%TYPE;
1643: v_middle_name per_all_people_f.middle_names%TYPE;
1644: v_ssn per_all_people_f.national_identifier%TYPE;
1645: v_dob per_all_people_f.date_of_birth%TYPE;
1646: v_date_start per_periods_of_service.date_start%TYPE;
1647: v_header number;
1640: v_person_id per_all_people_f.person_id%TYPE;
1641: v_last_name per_all_people_f.last_name%TYPE;
1642: v_first_name per_all_people_f.first_name%TYPE;
1643: v_middle_name per_all_people_f.middle_names%TYPE;
1644: v_ssn per_all_people_f.national_identifier%TYPE;
1645: v_dob per_all_people_f.date_of_birth%TYPE;
1646: v_date_start per_periods_of_service.date_start%TYPE;
1647: v_header number;
1648: v_buffer varchar2(120);
1641: v_last_name per_all_people_f.last_name%TYPE;
1642: v_first_name per_all_people_f.first_name%TYPE;
1643: v_middle_name per_all_people_f.middle_names%TYPE;
1644: v_ssn per_all_people_f.national_identifier%TYPE;
1645: v_dob per_all_people_f.date_of_birth%TYPE;
1646: v_date_start per_periods_of_service.date_start%TYPE;
1647: v_header number;
1648: v_buffer varchar2(120);
1649: v_boolean boolean;