APPS.PV_PARTNER_GEO_MATCH_PVT dependencies on DUAL

Line 275: FROM dual;

271: -- If the code is the same, try to see if the partner address
272: -- exists in JTF_LOC_HIERARCHIES_VL.
273: SELECT substr(l_ordered_loc_rec.lowest_code, instr(l_ordered_loc_rec.lowest_code, '-')+1)
274: INTO l_postal_code_start
275: FROM dual;
276:
277: SELECT substr(l_ordered_loc_rec.lowest_code, 1, instr(l_ordered_loc_rec.lowest_code, '-')-1)
278: INTO l_postal_code_end
279: FROM dual;

Line 279: FROM dual;

275: FROM dual;
276:
277: SELECT substr(l_ordered_loc_rec.lowest_code, 1, instr(l_ordered_loc_rec.lowest_code, '-')-1)
278: INTO l_postal_code_end
279: FROM dual;
280:
281: IF (PV_DEBUG_HIGH_ON) THEN
282: PVX_UTILITY_PVT.debug_message('l_postal_code_start = ' || l_postal_code_start);
283: END IF;