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 1544: --p_location_id hr_locations_all.location_id%TYPE := jg_zz_company_info.get_location_id;

1540: Get the location id from jg_zz_company_info.get_location_id.
1541: Profile option JGZZ_COMP_ID is to be setup for non multi org environments
1542: *************************************************************************/
1543:
1544: --p_location_id hr_locations_all.location_id%TYPE := jg_zz_company_info.get_location_id;
1545:
1546: company_name xle_firstparty_information_v.name%TYPE;
1547: company_nit xle_firstparty_information_v.registration_number%TYPE;
1548: --company_vdigit hr_locations_all.global_attribute12%TYPE;

Line 1548: --company_vdigit hr_locations_all.global_attribute12%TYPE;

1544: --p_location_id hr_locations_all.location_id%TYPE := jg_zz_company_info.get_location_id;
1545:
1546: company_name xle_firstparty_information_v.name%TYPE;
1547: company_nit xle_firstparty_information_v.registration_number%TYPE;
1548: --company_vdigit hr_locations_all.global_attribute12%TYPE;
1549: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1550: company_address xle_firstparty_information_v.address_line_1%TYPE;
1551: -- Bug 12964047 Start
1552: area_code hr_locations_all.telephone_number_1%TYPE;

Line 1552: area_code hr_locations_all.telephone_number_1%TYPE;

1548: --company_vdigit hr_locations_all.global_attribute12%TYPE;
1549: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1550: company_address xle_firstparty_information_v.address_line_1%TYPE;
1551: -- Bug 12964047 Start
1552: area_code hr_locations_all.telephone_number_1%TYPE;
1553: telephone_number hr_locations_all.telephone_number_2%TYPE;
1554: -- Bug 12964047 End
1555: city_code xle_firstparty_information_v.town_or_city%TYPE;
1556: identifi_register VARCHAR2(2000);

Line 1553: telephone_number hr_locations_all.telephone_number_2%TYPE;

1549: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1550: company_address xle_firstparty_information_v.address_line_1%TYPE;
1551: -- Bug 12964047 Start
1552: area_code hr_locations_all.telephone_number_1%TYPE;
1553: telephone_number hr_locations_all.telephone_number_2%TYPE;
1554: -- Bug 12964047 End
1555: city_code xle_firstparty_information_v.town_or_city%TYPE;
1556: identifi_register VARCHAR2(2000);
1557: movement_register VARCHAR2(2000);

Line 1666: and closed register from HR_LOCATIONS Table

1662: END IF;
1663:
1664: /***************************************************************
1665: Select Company Information required for identification register
1666: and closed register from HR_LOCATIONS Table
1667: ***************************************************************/
1668:
1669: BEGIN
1670:

Line 1690: hr_locations hr

1686: --company_vdigit,
1687: city_code,
1688: economic_activity_code
1689: FROM xle_firstparty_information_v le,
1690: hr_locations hr
1691: WHERE le.legal_entity_id = p_legal_entity_id
1692: AND hr.location_id = le.location_id;
1693:
1694: EXCEPTION