APPS.PER_PERUSHRM_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 764: ,hr_organization_information hoi4

760: ,hr_locations_all hl
761: ,hr_soft_coding_keyflex hscf
762: ,per_all_assignments_f paf
763: ,per_periods_of_service pps
764: ,hr_organization_information hoi4
765: ,hr_organization_information hoi3
766: ,hr_organization_information hoi2
767: ,hr_organization_information hoi1
768: ,hr_organization_units hou

Line 765: ,hr_organization_information hoi3

761: ,hr_soft_coding_keyflex hscf
762: ,per_all_assignments_f paf
763: ,per_periods_of_service pps
764: ,hr_organization_information hoi4
765: ,hr_organization_information hoi3
766: ,hr_organization_information hoi2
767: ,hr_organization_information hoi1
768: ,hr_organization_units hou
769: Where

Line 766: ,hr_organization_information hoi2

762: ,per_all_assignments_f paf
763: ,per_periods_of_service pps
764: ,hr_organization_information hoi4
765: ,hr_organization_information hoi3
766: ,hr_organization_information hoi2
767: ,hr_organization_information hoi1
768: ,hr_organization_units hou
769: Where
770: pps.person_id = ppf.person_id

Line 767: ,hr_organization_information hoi1

763: ,per_periods_of_service pps
764: ,hr_organization_information hoi4
765: ,hr_organization_information hoi3
766: ,hr_organization_information hoi2
767: ,hr_organization_information hoi1
768: ,hr_organization_units hou
769: Where
770: pps.person_id = ppf.person_id
771:

Line 819: ,hr_organization_information hoi4

815: ,hr_locations_all hl
816: ,hr_soft_coding_keyflex hscf
817: ,per_all_assignments_f paf
818: ,per_periods_of_service pps
819: ,hr_organization_information hoi4
820: ,hr_organization_information hoi3
821: ,hr_organization_information hoi2
822: ,hr_organization_information hoi1
823: ,hr_organization_units hou

Line 820: ,hr_organization_information hoi3

816: ,hr_soft_coding_keyflex hscf
817: ,per_all_assignments_f paf
818: ,per_periods_of_service pps
819: ,hr_organization_information hoi4
820: ,hr_organization_information hoi3
821: ,hr_organization_information hoi2
822: ,hr_organization_information hoi1
823: ,hr_organization_units hou
824: Where

Line 821: ,hr_organization_information hoi2

817: ,per_all_assignments_f paf
818: ,per_periods_of_service pps
819: ,hr_organization_information hoi4
820: ,hr_organization_information hoi3
821: ,hr_organization_information hoi2
822: ,hr_organization_information hoi1
823: ,hr_organization_units hou
824: Where
825: pps.person_id = ppf.person_id

Line 822: ,hr_organization_information hoi1

818: ,per_periods_of_service pps
819: ,hr_organization_information hoi4
820: ,hr_organization_information hoi3
821: ,hr_organization_information hoi2
822: ,hr_organization_information hoi1
823: ,hr_organization_units hou
824: Where
825: pps.person_id = ppf.person_id
826:

Line 1154: hr_organization_information hoi3

1150: , replace(hoi2.org_information1 ,'-',null) trans_federal_id
1151: , hou.organization_id trans_tax_unit_id
1152: , hou.location_id trans_location_id
1153: FROM
1154: hr_organization_information hoi3
1155: , hr_organization_information hoi2
1156: , hr_organization_information hoi1
1157: , hr_organization_units hou
1158: WHERE

Line 1155: , hr_organization_information hoi2

1151: , hou.organization_id trans_tax_unit_id
1152: , hou.location_id trans_location_id
1153: FROM
1154: hr_organization_information hoi3
1155: , hr_organization_information hoi2
1156: , hr_organization_information hoi1
1157: , hr_organization_units hou
1158: WHERE
1159: hou.business_group_id = P_BUSINESS_GROUP_ID

Line 1156: , hr_organization_information hoi1

1152: , hou.location_id trans_location_id
1153: FROM
1154: hr_organization_information hoi3
1155: , hr_organization_information hoi2
1156: , hr_organization_information hoi1
1157: , hr_organization_units hou
1158: WHERE
1159: hou.business_group_id = P_BUSINESS_GROUP_ID
1160: AND hoi1.organization_id = hou.organization_id

Line 1175: hr_organization_information hoi3

1171: CURSOR c_transmitter_count IS
1172: SELECT
1173: count(hou.organization_id)
1174: FROM
1175: hr_organization_information hoi3
1176: , hr_organization_units hou
1177: WHERE
1178: hou.business_group_id = P_BUSINESS_GROUP_ID
1179: AND hoi3.organization_id = hou.organization_id

Line 1194: ,hr_organization_information hoi4

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
1194: ,hr_organization_information hoi4
1195: ,hr_organization_information hoi3
1196: ,hr_organization_information hoi2
1197: ,hr_organization_information hoi1
1198: ,hr_organization_units hou

Line 1195: ,hr_organization_information hoi3

1191: ,hr_soft_coding_keyflex hscf
1192: ,hr_locations_all hl ,per_jobs job
1193: ,per_periods_of_service pps
1194: ,hr_organization_information hoi4
1195: ,hr_organization_information hoi3
1196: ,hr_organization_information hoi2
1197: ,hr_organization_information hoi1
1198: ,hr_organization_units hou
1199:

Line 1196: ,hr_organization_information hoi2

1192: ,hr_locations_all hl ,per_jobs job
1193: ,per_periods_of_service pps
1194: ,hr_organization_information hoi4
1195: ,hr_organization_information hoi3
1196: ,hr_organization_information hoi2
1197: ,hr_organization_information hoi1
1198: ,hr_organization_units hou
1199:
1200: Where

Line 1197: ,hr_organization_information hoi1

1193: ,per_periods_of_service pps
1194: ,hr_organization_information hoi4
1195: ,hr_organization_information hoi3
1196: ,hr_organization_information hoi2
1197: ,hr_organization_information hoi1
1198: ,hr_organization_units hou
1199:
1200: Where
1201: pps.person_id = ppf.person_id

Line 1248: ,hr_organization_information hoi4

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
1248: ,hr_organization_information hoi4
1249: ,hr_organization_information hoi3
1250: ,hr_organization_information hoi2
1251: ,hr_organization_information hoi1
1252: ,hr_organization_units hou

Line 1249: ,hr_organization_information hoi3

1245: ,hr_soft_coding_keyflex hscf
1246: ,hr_locations_all hl ,per_jobs job
1247: ,per_periods_of_service pps
1248: ,hr_organization_information hoi4
1249: ,hr_organization_information hoi3
1250: ,hr_organization_information hoi2
1251: ,hr_organization_information hoi1
1252: ,hr_organization_units hou
1253:

Line 1250: ,hr_organization_information hoi2

1246: ,hr_locations_all hl ,per_jobs job
1247: ,per_periods_of_service pps
1248: ,hr_organization_information hoi4
1249: ,hr_organization_information hoi3
1250: ,hr_organization_information hoi2
1251: ,hr_organization_information hoi1
1252: ,hr_organization_units hou
1253:
1254: Where

Line 1251: ,hr_organization_information hoi1

1247: ,per_periods_of_service pps
1248: ,hr_organization_information hoi4
1249: ,hr_organization_information hoi3
1250: ,hr_organization_information hoi2
1251: ,hr_organization_information hoi1
1252: ,hr_organization_units hou
1253:
1254: Where
1255: pps.person_id = ppf.person_id