APPS.PAY_MX_UTILITY dependencies on HR_ORGANIZATION_INFORMATION

Line 317: FROM hr_organization_information

313:
314: CURSOR c_gre_days( cp_organization_id number ) IS
315: SELECT fnd_number.canonical_to_number(nvl(org_information8,'-999')),
316: fnd_number.canonical_to_number(nvl(org_information9,'-999'))
317: FROM hr_organization_information
318: WHERE organization_id = cp_organization_id
319: AND org_information_context = 'MX_SOC_SEC_DETAILS';
320:
321: CURSOR c_le_days( cp_organization_id number ) IS

Line 324: FROM hr_organization_information

320:
321: CURSOR c_le_days( cp_organization_id number ) IS
322: SELECT fnd_number.canonical_to_number(nvl(org_information4,'-999')),
323: fnd_number.canonical_to_number(nvl(org_information5,'-999'))
324: FROM hr_organization_information
325: WHERE organization_id = cp_organization_id
326: AND org_information_context = 'MX_TAX_REGISTRATION';
327:
328: ln_leg_emplyr number;

Line 1138: hr_organization_information hoi

1134: CURSOR get_econ_zone
1135: IS
1136: SELECT hoi.org_information7
1137: FROM hr_organization_units hou,
1138: hr_organization_information hoi
1139: WHERE hou.organization_id = hoi.organization_id
1140: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
1141: AND hou.organization_id = P_CTX_TAX_UNIT_ID
1142: AND P_CTX_DATE_EARNED BETWEEN hou.date_from