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.

APPS.PAY_US_EMP_DT_TAX_VAL dependencies on PAY_US_STATES

Line 75: FROM pay_us_states pus,

71: CURSOR csr_chk_res_state
72: IS
73: SELECT pus1.state_code,
74: pus.state_code
75: FROM pay_us_states pus,
76: pay_us_states pus1,
77: per_addresses pa,
78: per_assignments_f paf
79: WHERE paf.assignment_id = p_assignment_id

Line 76: pay_us_states pus1,

72: IS
73: SELECT pus1.state_code,
74: pus.state_code
75: FROM pay_us_states pus,
76: pay_us_states pus1,
77: per_addresses pa,
78: per_assignments_f paf
79: WHERE paf.assignment_id = p_assignment_id
80: AND p_session_date BETWEEN paf.effective_start_date

Line 95: FROM pay_us_states pus,

91: SELECT pus1.state_code,
92: puc1.county_code,
93: pus.state_code,
94: puc.county_code
95: FROM pay_us_states pus,
96: pay_us_states pus1,
97: pay_us_counties puc,
98: pay_us_counties puc1,
99: per_addresses pa,

Line 96: pay_us_states pus1,

92: puc1.county_code,
93: pus.state_code,
94: puc.county_code
95: FROM pay_us_states pus,
96: pay_us_states pus1,
97: pay_us_counties puc,
98: pay_us_counties puc1,
99: per_addresses pa,
100: per_assignments_f paf

Line 124: FROM pay_us_states pus,

120: pucy1.city_code,
121: pus.state_code,
122: puc.county_code,
123: pucy.city_code
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,

Line 125: pay_us_states pus1,

121: pus.state_code,
122: puc.county_code,
123: pucy.city_code
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,

Line 278: FROM pay_us_states pus,

274: IS SELECT pus1.state_code,
275: pus.state_code,
276: paf.location_id,
277: hscf.segment18
278: FROM pay_us_states pus,
279: pay_us_states pus1,
280: hr_locations hl,
281: hr_locations hl1,
282: hr_soft_coding_keyflex hscf,

Line 279: pay_us_states pus1,

275: pus.state_code,
276: paf.location_id,
277: hscf.segment18
278: FROM pay_us_states pus,
279: pay_us_states pus1,
280: hr_locations hl,
281: hr_locations hl1,
282: hr_soft_coding_keyflex hscf,
283: per_assignments_f paf

Line 301: FROM pay_us_states pus,

297: pus.state_code,
298: puc.county_code,
299: paf.location_id,
300: hscf.segment18
301: FROM pay_us_states pus,
302: pay_us_states pus1,
303: pay_us_counties puc,
304: pay_us_counties puc1,
305: hr_locations hl,

Line 302: pay_us_states pus1,

298: puc.county_code,
299: paf.location_id,
300: hscf.segment18
301: FROM pay_us_states pus,
302: pay_us_states pus1,
303: pay_us_counties puc,
304: pay_us_counties puc1,
305: hr_locations hl,
306: hr_locations hl1,

Line 332: FROM pay_us_states pus,

328: puc.county_code,
329: pucy.city_code,
330: paf.location_id,
331: hscf.segment18
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,

Line 333: pay_us_states pus1,

329: pucy.city_code,
330: paf.location_id,
331: hscf.segment18
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,

Line 566: from pay_us_states pus,

562: where pef.assignment_id = p_assignment_id);
563:
564: cursor c_get_state_code(p_location_id in number) is
565: select pus.state_code
566: from pay_us_states pus,
567: hr_locations hl
568: where hl.location_id = p_location_id
569: and pus.state_abbrev = nvl(loc_information17,region_2);
570:

Line 572: l_work_state_code pay_us_states.state_code%type ;

568: where hl.location_id = p_location_id
569: and pus.state_abbrev = nvl(loc_information17,region_2);
570:
571:
572: l_work_state_code pay_us_states.state_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 ;

Line 573: l_new_work_state_code pay_us_states.state_code%type ;

569: and pus.state_abbrev = nvl(loc_information17,region_2);
570:
571:
572: l_work_state_code pay_us_states.state_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 ;

Line 574: l_work_state_name pay_us_states.state_name%type ;

570:
571:
572: l_work_state_code pay_us_states.state_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 ;

Line 759: from PAY_US_STATES pus

755: PER_ASSIGNMENTS_F paf
756: where paf.assignment_id = p_assignment_id
757: and hrl.location_id = paf.location_id
758: and exists (select null
759: from PAY_US_STATES pus
760: where pus.state_abbrev in (hrl.loc_information17,hrl.region_2)
761: and pus.state_code = p_state_code);
762:
763: CURSOR csr_check_ovrd_state is

Line 772: from PAY_US_STATES pus

768: where paf.assignment_id = p_assignment_id
769: and hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
770: and hrl.location_id = hscf.segment18
771: and exists (select null
772: from PAY_US_STATES pus
773: where pus.state_abbrev in (hrl.loc_information17,hrl.region_2)
774: and pus.state_code = p_state_code);
775:
776: /* Cursor to check if the county has been assigned as the county of a work

Line 787: PAY_US_STATES pus

783: where paf.assignment_id = p_assignment_id
784: and hrl.location_id = paf.location_id
785: and exists (select null
786: from PAY_US_COUNTIES puc,
787: PAY_US_STATES pus
788: where ((pus.state_abbrev = hrl.loc_information17
789: and puc.county_name = hrl.loc_information19)
790: or
791: (pus.state_abbrev = hrl.region_2

Line 807: PAY_US_STATES pus

803: and hscf.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
804: and hrl.location_id = hscf.segment18
805: and exists (select null
806: from PAY_US_COUNTIES puc,
807: PAY_US_STATES pus
808: where ((pus.state_abbrev = hrl.loc_information17
809: and puc.county_name = hrl.loc_information19)
810: or
811: (pus.state_abbrev = hrl.region_2

Line 829: PAY_US_STATES pus

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
832: and puci.city_name = hrl.loc_information18)
833: or

Line 855: PAY_US_STATES pus

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
858: and puci.city_name = hrl.loc_information18)
859: or

Line 1046: from PAY_US_STATES pus

1042: PER_ASSIGNMENTS_F paf
1043: where paf.assignment_id = p_assignment_id
1044: and pa.person_id = paf.person_id
1045: and exists (select null
1046: from PAY_US_STATES pus
1047: where pus.state_abbrev in (pa.add_information17,pa.region_2)
1048: and pus.state_code = p_state_code);
1049:
1050: /* Cursor to check if the county has been assigned as the county of a

Line 1061: PAY_US_STATES pus

1057: where paf.assignment_id = p_assignment_id
1058: and pa.person_id = paf.person_id
1059: and exists (select null
1060: from PAY_US_COUNTIES puc,
1061: PAY_US_STATES pus
1062: where ((pus.state_abbrev = pa.add_information17
1063: and puc.county_name = pa.add_information19)
1064: or
1065: (pus.state_abbrev = pa.region_2

Line 1083: PAY_US_STATES pus

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
1086: and puci.city_name = pa.add_information18)
1087: or

Line 1633: PAY_US_STATES pus,

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
1636: where paf.assignment_id = p_assignment_id
1637: and p_session_date between paf.effective_start_date and

Line 1709: PAY_US_STATES pus,

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,
1712: PER_ASSIGNMENTS_F paf
1713: where paf.assignment_id = p_assignment_id

Line 2072: PAY_US_STATES pus,

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
2075: and pus.state_abbrev = hrl.region_2
2076: and puc.state_code = pus.state_code

Line 2091: PAY_US_STATES pus,

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
2094: and pus.state_abbrev = hrl.loc_information17
2095: and puc.state_code = pus.state_code

Line 2282: PAY_US_STATES pus,

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
2285: where paf.assignment_id = p_assignment_id
2286: and p_session_date between paf.effective_start_date and