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.JL_CO_GL_MG_MEDIA_PKG dependencies on HR_LOCATIONS

Line 1439: --p_location_id hr.hr_locations_all.location_id%TYPE := jg_zz_company_info.get_location_id;

1435: Get the location id from jg_zz_company_info.get_location_id.
1436: Profile option JGZZ_COMP_ID is to be setup for non multi org environments
1437: *************************************************************************/
1438:
1439: --p_location_id hr.hr_locations_all.location_id%TYPE := jg_zz_company_info.get_location_id;
1440:
1441: company_name xle_firstparty_information_v.name%TYPE;
1442: company_nit xle_firstparty_information_v.registration_number%TYPE;
1443: --company_vdigit hr.hr_locations_all.global_attribute12%TYPE;

Line 1443: --company_vdigit hr.hr_locations_all.global_attribute12%TYPE;

1439: --p_location_id hr.hr_locations_all.location_id%TYPE := jg_zz_company_info.get_location_id;
1440:
1441: company_name xle_firstparty_information_v.name%TYPE;
1442: company_nit xle_firstparty_information_v.registration_number%TYPE;
1443: --company_vdigit hr.hr_locations_all.global_attribute12%TYPE;
1444: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1445: company_address xle_firstparty_information_v.address_line_1%TYPE;
1446: area_code hr.hr_locations_all.telephone_number_1%TYPE;
1447: telephone_number hr.hr_locations_all.telephone_number_2%TYPE;

Line 1446: area_code hr.hr_locations_all.telephone_number_1%TYPE;

1442: company_nit xle_firstparty_information_v.registration_number%TYPE;
1443: --company_vdigit hr.hr_locations_all.global_attribute12%TYPE;
1444: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1445: company_address xle_firstparty_information_v.address_line_1%TYPE;
1446: area_code hr.hr_locations_all.telephone_number_1%TYPE;
1447: telephone_number hr.hr_locations_all.telephone_number_2%TYPE;
1448: city_code xle_firstparty_information_v.town_or_city%TYPE;
1449: identifi_register VARCHAR2(2000);
1450: movement_register VARCHAR2(2000);

Line 1447: telephone_number hr.hr_locations_all.telephone_number_2%TYPE;

1443: --company_vdigit hr.hr_locations_all.global_attribute12%TYPE;
1444: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1445: company_address xle_firstparty_information_v.address_line_1%TYPE;
1446: area_code hr.hr_locations_all.telephone_number_1%TYPE;
1447: telephone_number hr.hr_locations_all.telephone_number_2%TYPE;
1448: city_code xle_firstparty_information_v.town_or_city%TYPE;
1449: identifi_register VARCHAR2(2000);
1450: movement_register VARCHAR2(2000);
1451: closed_register VARCHAR2(2000);

Line 1559: and closed register from HR_LOCATIONS Table

1555: END IF;
1556:
1557: /***************************************************************
1558: Select Company Information required for identification register
1559: and closed register from HR_LOCATIONS Table
1560: ***************************************************************/
1561:
1562: BEGIN
1563:

Line 1583: hr_locations hr

1579: --company_vdigit,
1580: city_code,
1581: economic_activity_code
1582: FROM xle_firstparty_information_v le,
1583: hr_locations hr
1584: WHERE le.legal_entity_id = p_legal_entity_id
1585: AND hr.location_id = le.location_id;
1586:
1587: EXCEPTION