752: ,hr_locations_all hl
753: ,hr_soft_coding_keyflex hscf
754: ,per_all_assignments_f paf
755: ,per_periods_of_service pps
756: ,hr_organization_information hoi4
757: ,hr_organization_information hoi3
758: ,hr_organization_information hoi2
759: ,hr_organization_information hoi1
760: ,hr_organization_units hou
753: ,hr_soft_coding_keyflex hscf
754: ,per_all_assignments_f paf
755: ,per_periods_of_service pps
756: ,hr_organization_information hoi4
757: ,hr_organization_information hoi3
758: ,hr_organization_information hoi2
759: ,hr_organization_information hoi1
760: ,hr_organization_units hou
761: Where
754: ,per_all_assignments_f paf
755: ,per_periods_of_service pps
756: ,hr_organization_information hoi4
757: ,hr_organization_information hoi3
758: ,hr_organization_information hoi2
759: ,hr_organization_information hoi1
760: ,hr_organization_units hou
761: Where
762: pps.person_id = ppf.person_id
755: ,per_periods_of_service pps
756: ,hr_organization_information hoi4
757: ,hr_organization_information hoi3
758: ,hr_organization_information hoi2
759: ,hr_organization_information hoi1
760: ,hr_organization_units hou
761: Where
762: pps.person_id = ppf.person_id
763:
807: ,hr_locations_all hl
808: ,hr_soft_coding_keyflex hscf
809: ,per_all_assignments_f paf
810: ,per_periods_of_service pps
811: ,hr_organization_information hoi4
812: ,hr_organization_information hoi3
813: ,hr_organization_information hoi2
814: ,hr_organization_information hoi1
815: ,hr_organization_units hou
808: ,hr_soft_coding_keyflex hscf
809: ,per_all_assignments_f paf
810: ,per_periods_of_service pps
811: ,hr_organization_information hoi4
812: ,hr_organization_information hoi3
813: ,hr_organization_information hoi2
814: ,hr_organization_information hoi1
815: ,hr_organization_units hou
816: Where
809: ,per_all_assignments_f paf
810: ,per_periods_of_service pps
811: ,hr_organization_information hoi4
812: ,hr_organization_information hoi3
813: ,hr_organization_information hoi2
814: ,hr_organization_information hoi1
815: ,hr_organization_units hou
816: Where
817: pps.person_id = ppf.person_id
810: ,per_periods_of_service pps
811: ,hr_organization_information hoi4
812: ,hr_organization_information hoi3
813: ,hr_organization_information hoi2
814: ,hr_organization_information hoi1
815: ,hr_organization_units hou
816: Where
817: pps.person_id = ppf.person_id
818:
1142: , replace(hoi2.org_information1 ,'-',null) trans_federal_id
1143: , hou.organization_id trans_tax_unit_id
1144: , hou.location_id trans_location_id
1145: FROM
1146: hr_organization_information hoi3
1147: , hr_organization_information hoi2
1148: , hr_organization_information hoi1
1149: , hr_organization_units hou
1150: WHERE
1143: , hou.organization_id trans_tax_unit_id
1144: , hou.location_id trans_location_id
1145: FROM
1146: hr_organization_information hoi3
1147: , hr_organization_information hoi2
1148: , hr_organization_information hoi1
1149: , hr_organization_units hou
1150: WHERE
1151: hou.business_group_id = P_BUSINESS_GROUP_ID
1144: , hou.location_id trans_location_id
1145: FROM
1146: hr_organization_information hoi3
1147: , hr_organization_information hoi2
1148: , hr_organization_information hoi1
1149: , hr_organization_units hou
1150: WHERE
1151: hou.business_group_id = P_BUSINESS_GROUP_ID
1152: AND hoi1.organization_id = hou.organization_id
1163: CURSOR c_transmitter_count IS
1164: SELECT
1165: count(hou.organization_id)
1166: FROM
1167: hr_organization_information hoi3
1168: , hr_organization_units hou
1169: WHERE
1170: hou.business_group_id = P_BUSINESS_GROUP_ID
1171: AND hoi3.organization_id = hou.organization_id
1182: ,per_all_assignments_f paf
1183: ,hr_soft_coding_keyflex hscf
1184: ,hr_locations_all hl ,per_jobs job
1185: ,per_periods_of_service pps
1186: ,hr_organization_information hoi4
1187: ,hr_organization_information hoi3
1188: ,hr_organization_information hoi2
1189: ,hr_organization_information hoi1
1190: ,hr_organization_units hou
1183: ,hr_soft_coding_keyflex hscf
1184: ,hr_locations_all hl ,per_jobs job
1185: ,per_periods_of_service pps
1186: ,hr_organization_information hoi4
1187: ,hr_organization_information hoi3
1188: ,hr_organization_information hoi2
1189: ,hr_organization_information hoi1
1190: ,hr_organization_units hou
1191:
1184: ,hr_locations_all hl ,per_jobs job
1185: ,per_periods_of_service pps
1186: ,hr_organization_information hoi4
1187: ,hr_organization_information hoi3
1188: ,hr_organization_information hoi2
1189: ,hr_organization_information hoi1
1190: ,hr_organization_units hou
1191:
1192: Where
1185: ,per_periods_of_service pps
1186: ,hr_organization_information hoi4
1187: ,hr_organization_information hoi3
1188: ,hr_organization_information hoi2
1189: ,hr_organization_information hoi1
1190: ,hr_organization_units hou
1191:
1192: Where
1193: pps.person_id = ppf.person_id
1236: ,per_all_assignments_f paf
1237: ,hr_soft_coding_keyflex hscf
1238: ,hr_locations_all hl ,per_jobs job
1239: ,per_periods_of_service pps
1240: ,hr_organization_information hoi4
1241: ,hr_organization_information hoi3
1242: ,hr_organization_information hoi2
1243: ,hr_organization_information hoi1
1244: ,hr_organization_units hou
1237: ,hr_soft_coding_keyflex hscf
1238: ,hr_locations_all hl ,per_jobs job
1239: ,per_periods_of_service pps
1240: ,hr_organization_information hoi4
1241: ,hr_organization_information hoi3
1242: ,hr_organization_information hoi2
1243: ,hr_organization_information hoi1
1244: ,hr_organization_units hou
1245:
1238: ,hr_locations_all hl ,per_jobs job
1239: ,per_periods_of_service pps
1240: ,hr_organization_information hoi4
1241: ,hr_organization_information hoi3
1242: ,hr_organization_information hoi2
1243: ,hr_organization_information hoi1
1244: ,hr_organization_units hou
1245:
1246: Where
1239: ,per_periods_of_service pps
1240: ,hr_organization_information hoi4
1241: ,hr_organization_information hoi3
1242: ,hr_organization_information hoi2
1243: ,hr_organization_information hoi1
1244: ,hr_organization_units hou
1245:
1246: Where
1247: pps.person_id = ppf.person_id