APPS.HZ_TAX_ASSIGNMENT_V2PUB dependencies on HZ_LOC_ASSIGNMENTS

Line 383: FROM HZ_LOC_ASSIGNMENTS

379: SELECT 'Y'
380: INTO l_loc_assg_exists
381: FROM DUAL
382: WHERE EXISTS ( SELECT 1
383: FROM HZ_LOC_ASSIGNMENTS
384: WHERE LOCATION_ID = p_location_id);
385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN
387: NULL;

Line 427: -- Below code will execute only if there is no record in hz_loc_assignments table

423: X_ADDR_WARN_MSG => x_addr_warn_msg,
424: X_ADDR_VAL_STATUS => x_addr_val_status,
425: X_STATUS => x_return_status);
426: ELSE
427: -- Below code will execute only if there is no record in hz_loc_assignments table
428: -- process_gnr will process the GNR and return success even if there is an error
429: -- in the validation.
430: HZ_GNR_PUB.process_gnr (
431: p_location_table_name => 'HZ_LOCATIONS',