APPS.PAY_US_EMP_DT_TAX_VAL dependencies on PAY_US_CITY_NAMES

Line 128: pay_us_city_names pucy,

124: FROM pay_us_states pus,
125: pay_us_states pus1,
126: pay_us_counties puc,
127: pay_us_counties puc1,
128: pay_us_city_names pucy,
129: pay_us_city_names pucy1,
130: per_addresses pa,
131: per_assignments_f paf
132: WHERE paf.assignment_id = p_assignment_id

Line 129: pay_us_city_names pucy1,

125: pay_us_states pus1,
126: pay_us_counties puc,
127: pay_us_counties puc1,
128: pay_us_city_names pucy,
129: pay_us_city_names pucy1,
130: per_addresses pa,
131: per_assignments_f paf
132: WHERE paf.assignment_id = p_assignment_id
133: AND p_session_date BETWEEN paf.effective_start_date

Line 336: pay_us_city_names pucy,

332: FROM pay_us_states pus,
333: pay_us_states pus1,
334: pay_us_counties puc,
335: pay_us_counties puc1,
336: pay_us_city_names pucy,
337: pay_us_city_names pucy1,
338: hr_locations hl,
339: hr_locations hl1,
340: hr_soft_coding_keyflex hscf,

Line 337: pay_us_city_names pucy1,

333: pay_us_states pus1,
334: pay_us_counties puc,
335: pay_us_counties puc1,
336: pay_us_city_names pucy,
337: pay_us_city_names pucy1,
338: hr_locations hl,
339: hr_locations hl1,
340: hr_soft_coding_keyflex hscf,
341: per_assignments_f paf

Line 577: l_work_city_code pay_us_city_names.city_code%type ;

573: l_new_work_state_code pay_us_states.state_code%type ;
574: l_work_state_name pay_us_states.state_name%type ;
575: l_work_county_code pay_us_counties.county_code%type ;
576: l_work_county_name pay_us_counties.county_name%type ;
577: l_work_city_code pay_us_city_names.city_code%type ;
578: l_work_city_name pay_us_city_names.city_name%type ;
579:
580: l_returned_warning1 varchar2(240) := NULL;
581:

Line 578: l_work_city_name pay_us_city_names.city_name%type ;

574: l_work_state_name pay_us_states.state_name%type ;
575: l_work_county_code pay_us_counties.county_code%type ;
576: l_work_county_name pay_us_counties.county_name%type ;
577: l_work_city_code pay_us_city_names.city_code%type ;
578: l_work_city_name pay_us_city_names.city_name%type ;
579:
580: l_returned_warning1 varchar2(240) := NULL;
581:
582: begin

Line 827: from PAY_US_CITY_NAMES puci,

823: PER_ASSIGNMENTS_F paf
824: where paf.assignment_id = p_assignment_id
825: and hrl.location_id = paf.location_id
826: and exists (select null
827: from PAY_US_CITY_NAMES puci,
828: PAY_US_COUNTIES puco,
829: PAY_US_STATES pus
830: where ((pus.state_abbrev = hrl.loc_information17
831: and puco.county_name = hrl.loc_information19

Line 853: from PAY_US_CITY_NAMES puci,

849: where paf.assignment_id = p_assignment_id
850: and hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
851: and hrl.location_id = hscf.segment18
852: and exists (select null
853: from PAY_US_CITY_NAMES puci,
854: PAY_US_COUNTIES puco,
855: PAY_US_STATES pus
856: where ((pus.state_abbrev = hrl.loc_information17
857: and puco.county_name = hrl.loc_information19

Line 1081: from PAY_US_CITY_NAMES puci,

1077: PER_ASSIGNMENTS_F paf
1078: where paf.assignment_id = p_assignment_id
1079: and pa.person_id = paf.person_id
1080: and exists (select null
1081: from PAY_US_CITY_NAMES puci,
1082: PAY_US_COUNTIES puco,
1083: PAY_US_STATES pus
1084: where ((pus.state_abbrev = pa.add_information17
1085: and puco.county_name = pa.add_information19

Line 1631: from PAY_US_CITY_NAMES puci,

1627: puci.city_code,
1628: pus.state_name,
1629: puc.county_name,
1630: puci.city_name
1631: from PAY_US_CITY_NAMES puci,
1632: PAY_US_COUNTIES puc,
1633: PAY_US_STATES pus,
1634: PER_ADDRESSES pa,
1635: PER_ASSIGNMENTS_F paf

Line 1707: from PAY_US_CITY_NAMES puci,

1703: puci.city_code,
1704: pus.state_name,
1705: puc.county_name,
1706: puci.city_name
1707: from PAY_US_CITY_NAMES puci,
1708: PAY_US_COUNTIES puc,
1709: PAY_US_STATES pus,
1710: HR_LOCATIONS hrl,
1711: HR_SOFT_CODING_KEYFLEX hscf,

Line 2070: from PAY_US_CITY_NAMES puci,

2066: puci.city_code,
2067: pus.state_name,
2068: puc.county_name,
2069: puci.city_name
2070: from PAY_US_CITY_NAMES puci,
2071: PAY_US_COUNTIES puc,
2072: PAY_US_STATES pus,
2073: HR_LOCATIONS hrl
2074: where hrl.location_id = cp_location_id

Line 2089: from PAY_US_CITY_NAMES puci,

2085: puci.city_code,
2086: pus.state_name,
2087: puc.county_name,
2088: puci.city_name
2089: from PAY_US_CITY_NAMES puci,
2090: PAY_US_COUNTIES puc,
2091: PAY_US_STATES pus,
2092: HR_LOCATIONS hrl
2093: where hrl.location_id = cp_location_id

Line 2280: from PAY_US_CITY_NAMES puci,

2276: puci.city_code,
2277: pus.state_name,
2278: puc.county_name,
2279: puci.city_name
2280: from PAY_US_CITY_NAMES puci,
2281: PAY_US_COUNTIES puc,
2282: PAY_US_STATES pus,
2283: PER_ADDRESSES pa,
2284: PER_ASSIGNMENTS_F paf