247: FROM DUAL
248: );
249:
250: /*
251: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrTask_rec.COUNTRY);
252: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrTask_rec.CITY);
253: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrTask_rec.POSTAL_CODE);
254: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrTask_rec.STATE);
255: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrTask_rec.AREA_CODE);
248: );
249:
250: /*
251: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrTask_rec.COUNTRY);
252: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrTask_rec.CITY);
253: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrTask_rec.POSTAL_CODE);
254: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrTask_rec.STATE);
255: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrTask_rec.AREA_CODE);
256: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrTask_rec.COUNTY);
249:
250: /*
251: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrTask_rec.COUNTRY);
252: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrTask_rec.CITY);
253: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrTask_rec.POSTAL_CODE);
254: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrTask_rec.STATE);
255: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrTask_rec.AREA_CODE);
256: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrTask_rec.COUNTY);
257: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrTask_rec.COMP_NAME_RANGE);
250: /*
251: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrTask_rec.COUNTRY);
252: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrTask_rec.CITY);
253: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrTask_rec.POSTAL_CODE);
254: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrTask_rec.STATE);
255: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrTask_rec.AREA_CODE);
256: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrTask_rec.COUNTY);
257: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrTask_rec.COMP_NAME_RANGE);
258: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrTask_rec.PROVINCE);
251: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrTask_rec.COUNTRY);
252: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrTask_rec.CITY);
253: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrTask_rec.POSTAL_CODE);
254: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrTask_rec.STATE);
255: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrTask_rec.AREA_CODE);
256: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrTask_rec.COUNTY);
257: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrTask_rec.COMP_NAME_RANGE);
258: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrTask_rec.PROVINCE);
259:
252: lp_Rec.squal_char02 := jtf_terr_char_360list(p_TerrTask_rec.CITY);
253: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrTask_rec.POSTAL_CODE);
254: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrTask_rec.STATE);
255: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrTask_rec.AREA_CODE);
256: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrTask_rec.COUNTY);
257: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrTask_rec.COMP_NAME_RANGE);
258: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrTask_rec.PROVINCE);
259:
260: lp_Rec.squal_num01 := jtf_terr_number_list(p_TerrTask_rec.PARTY_ID);
253: lp_Rec.squal_char03 := jtf_terr_char_360list(p_TerrTask_rec.POSTAL_CODE);
254: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrTask_rec.STATE);
255: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrTask_rec.AREA_CODE);
256: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrTask_rec.COUNTY);
257: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrTask_rec.COMP_NAME_RANGE);
258: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrTask_rec.PROVINCE);
259:
260: lp_Rec.squal_num01 := jtf_terr_number_list(p_TerrTask_rec.PARTY_ID);
261: lp_Rec.squal_num02 := jtf_terr_number_list(p_TerrTask_rec.PARTY_SITE_ID);
254: lp_Rec.squal_char04 := jtf_terr_char_360list(p_TerrTask_rec.STATE);
255: lp_Rec.squal_char05 := jtf_terr_char_360list(p_TerrTask_rec.AREA_CODE);
256: lp_Rec.squal_char06 := jtf_terr_char_360list(p_TerrTask_rec.COUNTY);
257: lp_Rec.squal_char07 := jtf_terr_char_360list(p_TerrTask_rec.COMP_NAME_RANGE);
258: lp_Rec.squal_char08 := jtf_terr_char_360list(p_TerrTask_rec.PROVINCE);
259:
260: lp_Rec.squal_num01 := jtf_terr_number_list(p_TerrTask_rec.PARTY_ID);
261: lp_Rec.squal_num02 := jtf_terr_number_list(p_TerrTask_rec.PARTY_SITE_ID);
262: lp_Rec.squal_num03 := jtf_terr_number_list(p_TerrTask_rec.NUM_OF_EMPLOYEES);