APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 915: FROM pay_us_emp_city_tax_rules_f pect,

911: AND pugu.id = p_id
912: AND pugu.assignment_id = p_assignment_id
913: AND EXISTS
914: (SELECT NULL
915: FROM pay_us_emp_city_tax_rules_f pect,
916: pay_us_city_school_dsts pcsd,
917: pay_us_modified_geocodes pumg
918: WHERE pect.assignment_id = p_assignment_id
919: AND pect.jurisdiction_code = pumg.state_code||'-'||pumg.county_code||'-'||pumg.old_city_code

Line 1206: records. So the Range Cursor is based on pay_us_emp_city_tax_rules_f */

1202:
1203: IF l_mode = 'GENERATE' THEN
1204:
1205: /*Under GENERATE Mode, we need to identify the Assignments based on the city tax
1206: records. So the Range Cursor is based on pay_us_emp_city_tax_rules_f */
1207:
1208: sqlstr := ' SELECT DISTINCT paf.person_id
1209: FROM per_all_assignments_f paf,
1210: pay_us_emp_city_tax_rules_f pect,

Line 1210: pay_us_emp_city_tax_rules_f pect,

1206: records. So the Range Cursor is based on pay_us_emp_city_tax_rules_f */
1207:
1208: sqlstr := ' SELECT DISTINCT paf.person_id
1209: FROM per_all_assignments_f paf,
1210: pay_us_emp_city_tax_rules_f pect,
1211: pay_us_modified_geocodes pumg
1212: WHERE pumg.process_type = ''PA''
1213: AND pect.assignment_id = paf.assignment_id
1214: AND pect.state_code = pumg.state_code

Line 1283: pay_us_emp_city_tax_rules_f ectr,

1279: p_endperson NUMBER
1280: ) IS
1281: SELECT DISTINCT ectr.assignment_id
1282: FROM per_all_assignments_f paf,
1283: pay_us_emp_city_tax_rules_f ectr,
1284: pay_us_modified_geocodes pumg
1285: WHERE pumg.state_code = ectr.state_code
1286: AND pumg.county_code = ectr.county_code
1287: AND pumg.old_city_code = ectr.city_code