eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CA_EE_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 205: hr_organization_units hou

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'
209: AND hoi.org_information8 IS NOT NULL;

Line 349: hr_organization_units hou

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
353: hoi.org_information_context = 'Canada Employer Identification' and

Line 418: hr_organization_units_v houv,

414: houv.town_or_city, houv.region_1,
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)))

Line 426: v_name hr_organization_units_v.name%TYPE;

422: upper(ltrim(rtrim(hoi.org_information_context)))
423: = 'BUSINESS GROUP INFORMATION'
424: and houv.business_group_id = p_business_group_id;
425:
426: v_name hr_organization_units_v.name%TYPE;
427: v_address_line_1 hr_organization_units_v.address_line_1%TYPE;
428: v_address_line_2 hr_organization_units_v.address_line_2%TYPE;
429: v_address_line_3 hr_organization_units_v.address_line_3%TYPE;
430: v_town_or_city hr_organization_units_v.town_or_city%TYPE;

Line 427: v_address_line_1 hr_organization_units_v.address_line_1%TYPE;

423: = 'BUSINESS GROUP INFORMATION'
424: and houv.business_group_id = p_business_group_id;
425:
426: v_name hr_organization_units_v.name%TYPE;
427: v_address_line_1 hr_organization_units_v.address_line_1%TYPE;
428: v_address_line_2 hr_organization_units_v.address_line_2%TYPE;
429: v_address_line_3 hr_organization_units_v.address_line_3%TYPE;
430: v_town_or_city hr_organization_units_v.town_or_city%TYPE;
431: v_region_1 hr_organization_units_v.region_1%TYPE;

Line 428: v_address_line_2 hr_organization_units_v.address_line_2%TYPE;

424: and houv.business_group_id = p_business_group_id;
425:
426: v_name hr_organization_units_v.name%TYPE;
427: v_address_line_1 hr_organization_units_v.address_line_1%TYPE;
428: v_address_line_2 hr_organization_units_v.address_line_2%TYPE;
429: v_address_line_3 hr_organization_units_v.address_line_3%TYPE;
430: v_town_or_city hr_organization_units_v.town_or_city%TYPE;
431: v_region_1 hr_organization_units_v.region_1%TYPE;
432: v_postal_code hr_organization_units_v.postal_code%TYPE;

Line 429: v_address_line_3 hr_organization_units_v.address_line_3%TYPE;

425:
426: v_name hr_organization_units_v.name%TYPE;
427: v_address_line_1 hr_organization_units_v.address_line_1%TYPE;
428: v_address_line_2 hr_organization_units_v.address_line_2%TYPE;
429: v_address_line_3 hr_organization_units_v.address_line_3%TYPE;
430: v_town_or_city hr_organization_units_v.town_or_city%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;

Line 430: v_town_or_city hr_organization_units_v.town_or_city%TYPE;

426: v_name hr_organization_units_v.name%TYPE;
427: v_address_line_1 hr_organization_units_v.address_line_1%TYPE;
428: v_address_line_2 hr_organization_units_v.address_line_2%TYPE;
429: v_address_line_3 hr_organization_units_v.address_line_3%TYPE;
430: v_town_or_city hr_organization_units_v.town_or_city%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;

Line 431: v_region_1 hr_organization_units_v.region_1%TYPE;

427: v_address_line_1 hr_organization_units_v.address_line_1%TYPE;
428: v_address_line_2 hr_organization_units_v.address_line_2%TYPE;
429: v_address_line_3 hr_organization_units_v.address_line_3%TYPE;
430: v_town_or_city hr_organization_units_v.town_or_city%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;

Line 432: v_postal_code hr_organization_units_v.postal_code%TYPE;

428: v_address_line_2 hr_organization_units_v.address_line_2%TYPE;
429: v_address_line_3 hr_organization_units_v.address_line_3%TYPE;
430: v_town_or_city hr_organization_units_v.town_or_city%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:

Line 433: v_country hr_organization_units_v.country%TYPE;

429: v_address_line_3 hr_organization_units_v.address_line_3%TYPE;
430: v_town_or_city hr_organization_units_v.town_or_city%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:

Line 434: v_organization_id hr_organization_units_v.organization_id%TYPE;

430: v_town_or_city hr_organization_units_v.town_or_city%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

Line 831: hr_organization_units hou,

827:
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