APPS.JAI_DRILLDOWN_UTILS_PKG dependencies on HR_LOCATIONS

Line 373: FROM hr_locations hr,

369:
370: IF ( pn_org_id = ln_source_org_id) THEN -- 'Distribution Out'
371: SELECT DISTINCT hr.description
372: INTO lv_des_loc_name
373: FROM hr_locations hr,
374: jai_rgm_dis_des_hdrs jrddh,
375: jai_rgm_dis_src_taxes jrdst,
376: jai_rgm_dis_des_taxes jrddt
377:

Line 389: FROM hr_locations hr,

385: RETURN(lv_des_loc_name);
386: ELSE -- 'Distribution In'
387: SELECT DISTINCT hr.description
388: INTO lv_des_loc_name
389: FROM hr_locations hr,
390: jai_rgm_dis_des_hdrs jrddh,
391: jai_rgm_dis_src_taxes jrdst,
392: jai_rgm_dis_des_taxes jrddt
393: