DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 427: FROM hr_all_organization_units

423: RETURN VARCHAR2 IS
424:
425: CURSOR c_get_bus_grp_id(cp_organization_id IN NUMBER) IS
426: SELECT business_group_id
427: FROM hr_all_organization_units
428: WHERE organization_id = cp_organization_id;
429:
430: CURSOR c_get_start_date(cp_tax_unit_id IN NUMBER) IS
431: SELECT pay_mx_utility.get_legi_param_val('END_DATE',LEGISLATIVE_PARAMETERS)