APPS.PAY_MX_TAX_FUNCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 265: hr_organization_information hoi

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

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

1595: P_CTX_EFFECTIVE_DATE DATE,
1596: P_CTX_JURISDICTION_CODE VARCHAR2
1597: ) RETURN VARCHAR2 AS
1598:
1599: -- Get data from hr_organization_information for the given Legal Employer
1600: --
1601: CURSOR c_get_rate_data(cp_legal_er_id NUMBER) IS
1602: SELECT DECODE(pml.legislation_info1,
1603: 'RANGE', org_information5,

Line 1605: FROM hr_organization_information hoi,

1601: CURSOR c_get_rate_data(cp_legal_er_id NUMBER) IS
1602: SELECT DECODE(pml.legislation_info1,
1603: 'RANGE', org_information5,
1604: 'FLAT_RATE', org_information3)
1605: FROM hr_organization_information hoi,
1606: pay_mx_legislation_info_f pml
1607: WHERE hoi.organization_id = cp_legal_er_id
1608: AND hoi.org_information_context = 'MX_STATE_TAX_RULES'
1609: AND hoi.org_information1 = p_ctx_jurisdiction_code

Line 2627: FROM hr_organization_information hoi

2623: ||'/'||hoi.org_information7),
2624: fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
2625: ||'/'||hoi.org_information8),
2626: paf.person_id
2627: FROM hr_organization_information hoi
2628: ,per_assignments_f paf
2629: WHERE hoi.organization_id =
2630: hr_mx_utility.get_legal_employer(paf.business_group_id,
2631: per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 2879: hr_organization_information hoi

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