APPS.PAY_US_TAX_INTERNAL dependencies on HR_SOFT_CODING_KEYFLEX

Line 24: from HR_SOFT_CODING_KEYFLEX hsck,

20: binary_integer;
21:
22: cursor csr_get_tax_loc(p_assignment number, p_session_dt date) is
23: select hsck.segment18
24: from HR_SOFT_CODING_KEYFLEX hsck,
25: PER_ASSIGNMENTS_F paf
26: where paf.assignment_id = p_assignment
27: and p_session_dt between paf.effective_start_date
28: and paf.effective_end_date

Line 164: from hr_soft_coding_keyflex sck

160: and nvl(adr.date_to, hr_api.g_eot)
161: and adr.primary_flag = 'Y'
162: and rownum = 1
163: and exists (select null
164: from hr_soft_coding_keyflex sck
165: where sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
166: and sck.segment1 is not null);
167: --
168:

Line 2886: from hr_soft_coding_keyflex sck

2882: and asg.soft_coding_keyflex_id is not null
2883: and asg.location_id is not null
2884: and asg.assignment_type = 'E'
2885: and exists (select null
2886: from hr_soft_coding_keyflex sck
2887: where sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
2888: and sck.segment1 is not null);
2889: --
2890: cursor csr_adr_defaulting_date is