DBA Data[Home] [Help]

APPS.PAY_MX_SUA_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 244: FROM hr_organization_information

240: WHERE hou.organization_id = p_gre_id;
241:
242: CURSOR c_get_imp_date(cp_organization_id IN NUMBER) IS
243: SELECT org_information6
244: FROM hr_organization_information
245: WHERE org_information_context = 'MX_TAX_REGISTRATION'
246: AND organization_id = cp_organization_id;
247:
248: CURSOR c_get_last_run_date IS

Line 860: FROM hr_organization_information

856: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
857:
858: CURSOR c_get_imp_date (cp_gre_id NUMBER) IS
859: SELECT org_information6
860: FROM hr_organization_information
861: WHERE org_information_context = 'MX_TAX_REGISTRATION'
862: AND organization_id = cp_gre_id;
863:
864: CURSOR c_get_bus_grp_id IS