APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 128: FROM per_all_assignments_f paf,

124: hr_utility.trace('Created PAY_PATCH_STATUS Entry with ID :'||l_id);
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

Line 156: FROM per_all_assignments_f paf

152: fnd_file.put_line(fnd_file.log,'No User Defined City changes entries for Upgrade');
153: fnd_file.put_line(fnd_file.log,'No Processing required');
154:
155: sqlstr := ' SELECT distinct paf.person_id
156: FROM per_all_assignments_f paf
157: WHERE 1=2
158: AND :pactid IS NOT NULL';
159:
160: END IF; /*l_upgrade_needed IF*/

Line 188: FROM per_all_assignments_f paf,

184: p_stperson NUMBER,
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'

Line 458: FROM per_all_assignments_f paf,

454: CLOSE get_emp_counts;
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