APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 129: pay_us_emp_city_tax_rules_f pect,

125: fnd_file.put_line(fnd_file.log,'Created PAY_PATCH_STATUS Entry with ID :'||l_id);
126:
127: sqlstr := ' SELECT DISTINCT paf.person_id
128: FROM per_all_assignments_f paf,
129: pay_us_emp_city_tax_rules_f pect,
130: pay_us_geo_update pugu,
131: pay_patch_status pps
132: WHERE pect.assignment_id = paf.assignment_id
133: AND substr(pugu.old_juri_code,1,2) = pect.state_code

Line 189: pay_us_emp_city_tax_rules_f ectr,

185: p_endperson NUMBER
186: ) IS
187: SELECT DISTINCT ectr.assignment_id
188: FROM per_all_assignments_f paf,
189: pay_us_emp_city_tax_rules_f ectr,
190: pay_us_geo_update pugu,
191: pay_patch_status pps
192: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
193: AND pps.phase = 'TO_BE_UPDATED'

Line 459: pay_us_emp_city_tax_rules_f pect,

455:
456: SELECT count(DISTINCT paf.assignment_id)
457: INTO l_assignments_to_be_updated
458: FROM per_all_assignments_f paf,
459: pay_us_emp_city_tax_rules_f pect,
460: pay_us_geo_update pugu,
461: pay_patch_status pps
462: WHERE pect.assignment_id = paf.assignment_id
463: AND substr(pugu.old_juri_code,1,2) = pect.state_code