[Home] [Help]
344: substr(pef.assignment_number,1,17) ,
345: substr(pgu.description,1,65)
346: from per_people_f ppf,
347: per_assignments_f pef,
348: pay_us_geo_update pgu,
349: pay_patch_status pps
350: where pef.assignment_id = pgu.assignment_id
351: and ppf.person_id = pef.person_id
352: and pgu.id = pps.id
543: pef.assignment_id ,
544: substr(pef.assignment_number,1,17)
545: from per_people_f ppf,
546: per_assignments_f pef,
547: pay_us_geo_update pgu,
548: pay_patch_status pps
549: where pgu.process_type = 'PERCENTAGE_OVER_100'
550: and pef.assignment_id = pgu.assignment_id
551: and ppf.person_id = pef.person_id
728: pef.assignment_id ,
729: substr(pef.assignment_number,1,17)
730: from per_people_f ppf,
731: per_assignments_f pef,
732: pay_us_geo_update pgu,
733: pay_patch_status pps
734: where pgu.process_type = 'MISSING_COUNTY_RECORDS'
735: and pef.assignment_id = pgu.assignment_id
736: and ppf.person_id = pef.person_id
915: pay_us_city_names pusc ,
916: pay_patch_status pps,
917: per_people_f ppf,
918: per_assignments_f pef,
919: pay_us_geo_update pgu
920: where pgu.process_type = 'PU'
921: and pef.assignment_id = pgu.assignment_id
922: and ppf.person_id = pef.person_id
923: and pgu.table_name is not null
1149: new_juri_code "New JD",
1150: substr(table_name,1,20)
1151: from per_people_f ppf,
1152: per_assignments_f pef,
1153: pay_us_geo_update pgu,
1154: pay_us_city_names pusc,
1155: pay_patch_status pps
1156: where pgu.process_type = 'UP'
1157: and pgu.table_name is not null
1366: old_juri_code ,
1367: new_juri_code
1368: from per_people_f ppf,
1369: per_assignments_f pef,
1370: pay_us_geo_update pgu,
1371: pay_us_city_names pusc,
1372: pay_patch_status pps ,
1373: pay_us_states pust,
1374: pay_us_counties puscn
2015: ,cp_geocode_patch_name in varchar
2016: ) is
2017:
2018: select /*+ ORDERED
2019: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2)
2020: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2021: distinct substr(ppf.full_name,1,40) ,
2022: pef.assignment_id ,
2023: substr(pef.assignment_number,1,17),
2023: substr(pef.assignment_number,1,17),
2024: substr(pusc.city_name,1,20),
2025: pgu.new_juri_code
2026: from pay_patch_status pps,
2027: pay_us_geo_update pgu,
2028: pay_us_city_names pusc,
2029: per_assignments_f pef,
2030: per_people_f ppf
2031: where pgu.process_type = 'NEW_CITY_RECORDS'
2219: ,cp_geocode_patch_name in varchar
2220: ) is
2221:
2222: select /*+ ORDERED
2223: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2 )
2224: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2225: distinct substr(ppf.full_name,1,40) ,
2226: pef.assignment_id ,
2227: substr(pef.assignment_number,1,17),
2227: substr(pef.assignment_number,1,17),
2228: substr(pusc.city_name,1,20),
2229: pgu.new_juri_code
2230: from pay_patch_status pps,
2231: pay_us_geo_update pgu,
2232: pay_us_city_names pusc,
2233: per_assignments_f pef,
2234: per_people_f ppf
2235: where pgu.process_type = 'NEW_VERTEX_RECORDS'
2428: ,cp_geocode_patch_name in varchar
2429: ) is
2430:
2431: select /*+ ORDERED
2432: INDEX (PAY_US_GEO_UPDATE PAY_US_GEO_UPDATE_N2 )
2433: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2434: distinct old_juri_code ,
2435: new_juri_code
2436: from pay_patch_status pps,
2433: INDEX (PAY_PATCH_STATUS PAY_PATCH_STATUS_N1) */
2434: distinct old_juri_code ,
2435: new_juri_code
2436: from pay_patch_status pps,
2437: pay_us_geo_update pgu
2438: where pgu.process_type = 'TAX_RULES_CHANGE'
2439: and pgu.process_mode = cp_process_mode
2440: and pgu.id = pps.id
2441: and pps.patch_name = cp_geocode_patch_name;