APPS.HR_AE_VALIDATE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 191: FROM hr_organization_information hoi,

187:
188: DECLARE
189: CURSOR csr_get_loc_nat IS
190: SELECT org_information1
191: FROM hr_organization_information hoi,
192: per_person_types pty
193: WHERE pty.person_type_id = p_person_type_id
194: AND pty.business_group_id = hoi.organization_id
195: AND hoi.org_information_context = 'AE_BG_DETAILS';

Line 219: hr_organization_information hoi

215:
216: CURSOR csr_fetch_bg_id IS
217: SELECT distinct pty.business_group_id
218: FROM per_person_types pty,
219: hr_organization_information hoi
220: WHERE pty.person_type_id = p_person_type_id
221: AND pty.business_group_id = hoi.organization_id;
222:
223: CURSOR csr_val_mar_status (l_bg_id NUMBER) IS

Line 1012: hr_organization_information hoi

1008:
1009: CURSOR csr_fetch_bus_id IS
1010: SELECT distinct paf.business_group_id
1011: FROM per_all_people_f paf,
1012: hr_organization_information hoi
1013: WHERE paf.person_id = p_person_id
1014: AND paf.business_group_id = hoi.organization_id;
1015:
1016: l_bg_id number;

Line 1053: hr_organization_information hoi

1049:
1050: CURSOR csr_fetch_bus_id IS
1051: SELECT distinct pad.business_group_id
1052: FROM per_addresses pad,
1053: hr_organization_information hoi
1054: WHERE pad.ADDRESS_ID = p_address_id
1055: AND pad.business_group_id = hoi.organization_id;
1056:
1057: l_bg_id number;

Line 1126: hr_organization_information hoi

1122: CURSOR csr_fetch_bus_id IS
1123: SELECT distinct paaf.business_group_id
1124: FROM per_all_assignments_f paaf,
1125: hr_locations_all hl,
1126: hr_organization_information hoi
1127: WHERE paaf.location_id = p_location_id
1128: and paaf.location_id = hl.location_id
1129: AND paaf.business_group_id = hoi.organization_id;
1130: