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.

[Home] [Help]

APPS.PER_CA_EE_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS_V

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