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.PAY_MX_TAX_FUNCTIONS dependencies on HR_ORGANIZATION_UNITS

Line 264: hr_organization_units hou,

260:
261: CURSOR csr_get_min_wage (p_gre_id NUMBER, p_effective_date DATE) IS
262: SELECT fnd_number.canonical_to_number(plif.legislation_info2)
263: FROM pay_mx_legislation_info_f plif,
264: hr_organization_units hou,
265: hr_organization_information hoi
266: WHERE hou.organization_id = hoi.organization_id
267: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
268: AND (DECODE (UPPER(p_range_basis),

Line 280: l_gre_id hr_organization_units.organization_id%type;

276: AND plif.effective_end_date;
277:
278: l_min_wage NUMBER;
279: l_scl_id NUMBER;
280: l_gre_id hr_organization_units.organization_id%type;
281: l_location_id hr_locations.location_id%type;
282: l_business_group_id NUMBER;
283: l_effective_date DATE;
284: l_is_ambiguous BOOLEAN;

Line 1556: l_legal_employer_name hr_organization_units.name%TYPE;

1552: ) RETURN NUMBER AS
1553:
1554: l_proc_name VARCHAR2(100);
1555: l_row_name VARCHAR2(300);
1556: l_legal_employer_name hr_organization_units.name%TYPE;
1557: l_head_count NUMBER;
1558: BEGIN
1559:
1560: l_proc_name := g_proc_name || 'GET_MX_EE_HEAD_COUNT';

Line 2878: FROM hr_organization_units hou,

2874:
2875: CURSOR get_econ_zone
2876: IS
2877: SELECT hoi.org_information7
2878: FROM hr_organization_units hou,
2879: hr_organization_information hoi
2880: WHERE hou.organization_id = hoi.organization_id
2881: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
2882: AND hou.organization_id = P_CTX_TAX_UNIT_ID