eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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 1629: from PAY_US_CITY_NAMES puci,

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

Line 1705: from PAY_US_CITY_NAMES puci,

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

Line 2068: from PAY_US_CITY_NAMES puci,

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

Line 2087: from PAY_US_CITY_NAMES puci,

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

Line 2278: from PAY_US_CITY_NAMES puci,

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