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 325: hr_organization_units hou,

321:
322: CURSOR csr_get_min_wage (p_gre_id NUMBER, p_effective_date DATE) IS
323: SELECT fnd_number.canonical_to_number(plif.legislation_info2)
324: FROM pay_mx_legislation_info_f plif,
325: hr_organization_units hou,
326: hr_organization_information hoi
327: WHERE hou.organization_id = hoi.organization_id
328: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
329: AND (DECODE (UPPER(p_range_basis),

Line 341: l_gre_id hr_organization_units.organization_id%type;

337: AND plif.effective_end_date;
338:
339: l_min_wage NUMBER;
340: l_scl_id NUMBER;
341: l_gre_id hr_organization_units.organization_id%type;
342: l_location_id hr_locations.location_id%type;
343: l_business_group_id NUMBER;
344: l_effective_date DATE;
345: l_is_ambiguous BOOLEAN;

Line 1690: l_legal_employer_name hr_organization_units.name%TYPE;

1686: ) RETURN NUMBER AS
1687:
1688: l_proc_name VARCHAR2(100);
1689: l_row_name VARCHAR2(300);
1690: l_legal_employer_name hr_organization_units.name%TYPE;
1691: l_head_count NUMBER;
1692: BEGIN
1693:
1694: l_proc_name := g_proc_name || 'GET_MX_EE_HEAD_COUNT';

Line 4176: FROM hr_organization_units hou,

4172:
4173: CURSOR get_econ_zone
4174: IS
4175: SELECT hoi.org_information7
4176: FROM hr_organization_units hou,
4177: hr_organization_information hoi
4178: WHERE hou.organization_id = hoi.organization_id
4179: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
4180: AND hou.organization_id = P_CTX_TAX_UNIT_ID