APPS.PAY_US_EMP_DT_TAX_VAL dependencies on HR_SOFT_CODING_KEYFLEX

Line 282: hr_soft_coding_keyflex hscf,

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
284: WHERE paf.assignment_id = p_assignment_id
285: AND p_session_date BETWEEN paf.effective_start_date
286: AND paf.effective_end_date

Line 307: hr_soft_coding_keyflex hscf,

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
309: WHERE paf.assignment_id = p_assignment_id
310: AND p_session_date BETWEEN paf.effective_start_date
311: AND paf.effective_end_date

Line 340: hr_soft_coding_keyflex hscf,

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
342: WHERE paf.assignment_id = p_assignment_id
343: AND p_session_date BETWEEN paf.effective_start_date
344: AND paf.effective_end_date

Line 766: HR_SOFT_CODING_KEYFLEX hscf,

762:
763: CURSOR csr_check_ovrd_state is
764: select 1
765: from HR_LOCATIONS hrl,
766: HR_SOFT_CODING_KEYFLEX hscf,
767: PER_ASSIGNMENTS_F paf
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

Line 800: HR_SOFT_CODING_KEYFleX hscf,

796:
797: CURSOR csr_check_ovrd_county is
798: select 1
799: from HR_LOCATIONS hrl,
800: HR_SOFT_CODING_KEYFleX hscf,
801: PER_ASSIGNMENTS_F paf
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

Line 847: HR_SOFT_CODING_KEYFLEX hscf,

843:
844: CURSOR csr_check_ovrd_city is
845: select 1
846: from HR_LOCATIONS hrl,
847: HR_SOFT_CODING_KEYFLEX hscf,
848: PER_ASSIGNMENTS_F paf
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

Line 1709: HR_SOFT_CODING_KEYFLEX hscf,

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
1711: where paf.assignment_id = p_assignment_id
1712: and p_session_date between paf.effective_start_date and
1713: paf.effective_end_date

Line 2054: from HR_SOFT_CODING_KEYFLEX hsc,

2050:
2051: /* Override Assignment Data */
2052: cursor csr_get_asgn_locations is
2053: select paf.location_id, hsc.segment18
2054: from HR_SOFT_CODING_KEYFLEX hsc,
2055: PER_ASSIGNMENTS_F paf
2056: where paf.assignment_id = p_assignment_id
2057: and p_session_date between paf.effective_start_date and
2058: paf.effective_end_date