APPS.PAY_US_TAX_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 453: hr_soft_coding_keyflex hsck

449: ftr.effective_start_date,
450: paf.assignment_id,
451: hsck.segment1
452: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,
453: hr_soft_coding_keyflex hsck
454: where paf.person_id = p_person_id
455: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
456: and paf.assignment_id = ftr.assignment_id
457: and paf.assignment_type = 'E'

Line 463: hr_soft_coding_keyflex sck

459: and p_effective_date between paf.effective_start_date and paf.effective_end_date
460: and p_effective_date between ftr.effective_start_date and ftr.effective_end_date
461: and not exists( select 'x'
462: from hr_organization_information hoi,
463: hr_soft_coding_keyflex sck
464: where paf.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
465: and sck.segment1 = hoi.organization_id
466: and hoi.org_information_context = '1099R Magnetic Report Rules')
467: for update nowait;

Line 480: hr_soft_coding_keyflex hsck

476: stif.sta_information7,
477: hsck.segment1
478: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
479: pay_us_state_tax_info_f stif, pay_us_states pus,
480: hr_soft_coding_keyflex hsck
481: where paf.person_id = p_person_id
482: and paf.assignment_id = str.assignment_id
483: and paf.assignment_type = 'E'
484: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 494: hr_soft_coding_keyflex sck

490: and p_effective_date between paf.effective_start_date and paf.effective_end_date
491: and p_effective_date between str.effective_start_date and str.effective_end_date
492: and not exists( select 'x'
493: from hr_organization_information hoi,
494: hr_soft_coding_keyflex sck
495: where paf.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
496: and sck.segment1 = hoi.organization_id
497: and hoi.org_information_context = '1099R Magnetic Report Rules')
498: for update nowait;

Line 865: hr_soft_coding_keyflex sck

861: CURSOR c_primary_retiree_asg IS
862: select 'x'
863: from per_assignments_f paf,
864: hr_organization_information hoi,
865: hr_soft_coding_keyflex sck
866: where paf.person_id = p_person_id
867: and paf.primary_flag = 'Y'
868: and paf.effective_end_date >= p_effective_date
869: and paf.soft_coding_keyflex_id = sck.soft_coding_keyflex_id