APPS.PER_CA_EE_EXTRACT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 204: FROM hr_organization_information hoi,

200:
201: CURSOR cur_gre_naic IS
202: SELECT hoi.organization_id,
203: hoi.org_information8
204: FROM hr_organization_information hoi,
205: hr_organization_units hou
206: WHERE hou.business_group_id = p_business_group_id
207: AND hou.organization_id = hoi.organization_id
208: AND hoi.org_information_context = 'Canada Employer Identification'

Line 348: hr_organization_information hoi,

344: cursor cur_gre_without_naic is
345: select
346: hou.name gre_name
347: from
348: hr_organization_information hoi,
349: hr_organization_units hou
350: where
351: hou.business_group_id = p_business_group_id and
352: hou.organization_id = hoi.organization_id and

Line 419: hr_organization_information hoi

415: houv.postal_code,houv.country, houv.organization_id ,
416: hoi.org_information1
417: from
418: hr_organization_units_v houv,
419: hr_organization_information hoi
420: where
421: houv.organization_id=hoi.organization_id and
422: upper(ltrim(rtrim(hoi.org_information_context)))
423: = 'BUSINESS GROUP INFORMATION'

Line 435: v_short_name hr_organization_information.org_information1%TYPE;

431: v_region_1 hr_organization_units_v.region_1%TYPE;
432: v_postal_code hr_organization_units_v.postal_code%TYPE;
433: v_country hr_organization_units_v.country%TYPE;
434: v_organization_id hr_organization_units_v.organization_id%TYPE;
435: v_short_name hr_organization_information.org_information1%TYPE;
436:
437:
438: cursor cur_employee_info is
439: select

Line 446: hr_organization_information

442: org_information2 contact_name,
443: org_information4 contact_position,
444: org_information5 contact_phone
445: from
446: hr_organization_information
447: where
448: upper(ltrim(rtrim(org_information_context)))
449: = 'EMPLOYMENT EQUITY INFORMATION' and
450: organization_id = v_organization_id;

Line 724: hr_organization_information hoi,

720: hl.lookup_code lcode
721: from
722: hr_lookups hl,
723: hr_soft_coding_keyflex hsck ,
724: hr_organization_information hoi,
725: per_assignments_f paf,
726: per_people_f ppf,
727: per_person_types ppt,
728: per_jobs pj,

Line 832: hr_organization_information hoi

828: cursor cur_gre_id(p_naic varchar2) is
829: select hou.organization_id
830: from
831: hr_organization_units hou,
832: hr_organization_information hoi
833: where
834: hoi.organization_id = hou.organization_id and
835: hou.business_group_id = p_business_group_id and
836: hoi.org_information_context = 'Canada Employer Identification' and