DBA Data[Home] [Help]

APPS.JAI_RCV_RT_TRIGGER_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 69: FROM hr_all_organization_units haou,

65:
66: /*Added cursor get_rma_loc for Bug 15936238 by mmurtuza*/
67: cursor get_rma_loc(p_organization_id number) is
68: SELECT haou.location_id
69: FROM hr_all_organization_units haou,
70: hr_locations_all hla
71: WHERE haou.organization_id = p_organization_id
72: AND haou.location_id = hla.location_id;
73: