[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)
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
1636: where paf.assignment_id = p_assignment_id
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,
1712: PER_ASSIGNMENTS_F paf
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
2075: and pus.state_abbrev = hrl.region_2
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
2094: and pus.state_abbrev = hrl.loc_information17
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
2285: where paf.assignment_id = p_assignment_id