APPS.MTH_UTIL_PKG dependencies on MTH_ORGANIZATIONS_L

Line 59: FROM mth_plants_d, mth_systems_setup,mth_organizations_l

55: --the rows in the mth_run_log will be at organization granularity
56: CURSOR c_ebs_orgs IS
57: SELECT ebs_organization_id,organization_code,
58: source,plant_pk,system_fk_key,from_date
59: FROM mth_plants_d, mth_systems_setup,mth_organizations_l
60: WHERE system_pk_key = system_fk_key
61: AND system_pk = p_db_global_name
62: AND NVL(to_date,TRUNC(SYSDATE)) >= TRUNC(SYSDATE)--pick active plants only
63: AND plant_fk_key=plant_pk_key;

Line 261: FROM mth_plants_d, mth_systems_setup,mth_organizations_l

257:
258: CURSOR c_ebs_orgs
259: IS
260: SELECT ebs_organization_id,system_fk_key
261: FROM mth_plants_d, mth_systems_setup,mth_organizations_l
262: WHERE system_pk_key = system_fk_key
263: AND system_pk = p_db_global_name
264: AND NVL(to_date,TRUNC(SYSDATE)) >= TRUNC(SYSDATE)--pick active plants only
265: AND plant_fk_key=plant_pk_key;