[Home] [Help]
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
101: WHERE paf.assignment_id = p_assignment_id
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
101: WHERE paf.assignment_id = p_assignment_id
102: AND p_session_date BETWEEN paf.effective_start_date
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,
130: per_addresses pa,
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,
130: per_addresses pa,
131: per_assignments_f paf
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,
307: hr_soft_coding_keyflex hscf,
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,
307: hr_soft_coding_keyflex hscf,
308: per_assignments_f paf
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,
338: hr_locations hl,
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,
338: hr_locations hl,
339: hr_locations hl1,
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 ;
579:
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 ;
579:
580: l_returned_warning1 varchar2(240) := NULL;
782: PER_ASSIGNMENTS_F paf
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
802: where paf.assignment_id = p_assignment_id
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
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
832: and puci.city_name = hrl.loc_information18)
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
858: and puci.city_name = hrl.loc_information18)
1056: PER_ASSIGNMENTS_F paf
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
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
1086: and puci.city_name = pa.add_information18)
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
1634: where paf.assignment_id = p_assignment_id
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,
1710: PER_ASSIGNMENTS_F paf
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
2073: and pus.state_abbrev = hrl.region_2
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
2092: and pus.state_abbrev = hrl.loc_information17
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
2283: where paf.assignment_id = p_assignment_id