APPS.PAY_MX_TAX_FUNCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 326: hr_organization_information hoi

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),
330: 'MW', 'MW'||hoi.org_information7) = plif.legislation_info1 OR

Line 1733: -- Get data from hr_organization_information for the given Legal Employer

1729: P_CTX_EFFECTIVE_DATE DATE,
1730: P_CTX_JURISDICTION_CODE VARCHAR2
1731: ) RETURN VARCHAR2 AS
1732:
1733: -- Get data from hr_organization_information for the given Legal Employer
1734: --
1735: CURSOR c_get_rate_data(cp_legal_er_id NUMBER) IS
1736: SELECT DECODE(pml.legislation_info1,
1737: 'RANGE', org_information5,

Line 1739: FROM hr_organization_information hoi,

1735: CURSOR c_get_rate_data(cp_legal_er_id NUMBER) IS
1736: SELECT DECODE(pml.legislation_info1,
1737: 'RANGE', org_information5,
1738: 'FLAT_RATE', org_information3)
1739: FROM hr_organization_information hoi,
1740: pay_mx_legislation_info_f pml
1741: WHERE hoi.organization_id = cp_legal_er_id
1742: AND hoi.org_information_context = 'MX_STATE_TAX_RULES'
1743: AND hoi.org_information1 = p_ctx_jurisdiction_code

Line 3925: FROM hr_organization_information hoi

3921: ||'/'||hoi.org_information7),
3922: fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
3923: ||'/'||hoi.org_information8),
3924: paf.person_id
3925: FROM hr_organization_information hoi
3926: ,per_assignments_f paf
3927: WHERE hoi.organization_id =
3928: hr_mx_utility.get_legal_employer(paf.business_group_id,
3929: per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 4177: hr_organization_information hoi

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
4181: AND P_CTX_DATE_EARNED BETWEEN hou.date_from