DBA Data[Home] [Help]

APPS.ZX_SRVC_TYP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 6999: FROM hr_organization_units hr

6995: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_party_id(p_trx_line_index) IS NOT NULL THEN
6996: BEGIN
6997: SELECT hr.location_id
6998: INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_location_id(p_trx_line_index)
6999: FROM hr_organization_units hr
7000: WHERE hr.organization_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_party_id(p_trx_line_index);
7001: EXCEPTION
7002: WHEN OTHERS THEN
7003: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_location_id(p_trx_line_index) := NULL;