APPS.HZ_POPULATE_BOT_PKG dependencies on HZ_LOCATIONS_EXT_B

Line 3788: FROM HZ_LOCATIONS_EXT_B c

3784: AND rownum = 1;
3785:
3786: CURSOR C_child_loc IS
3787: SELECT c.LAST_UPDATE_DATE lud, c.LOCATION_ID parent_id, c.extension_id child_id, 'LOCATION' bo_code, 'HZ_LOCATIONS' parent_entity
3788: FROM HZ_LOCATIONS_EXT_B c
3789: WHERE c.EXTENSION_ID = P_EXTENSION_ID
3790: AND rownum = 1;
3791:
3792: CURSOR C_child_ps IS