DBA Data[Home] [Help]

APPS.ZX_SRVC_TYP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 7837: FROM hr_organization_units hr

7833: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_party_id(p_trx_line_index) IS NOT NULL THEN
7834: BEGIN
7835: SELECT hr.location_id
7836: INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_location_id(p_trx_line_index)
7837: FROM hr_organization_units hr
7838: WHERE hr.organization_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_party_id(p_trx_line_index);
7839: EXCEPTION
7840: WHEN OTHERS THEN
7841: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_location_id(p_trx_line_index) := NULL;