APPS.PAY_US_EMPLOYEE_BALANCES dependencies on HR_SOFT_CODING_KEYFLEX

Line 629: hr_soft_coding_keyflex hsk

625: -- check to see if p_assignment_id exist as of l_date
626: select paf.assignment_id
627: into l_temp_assignment_id
628: from per_assignments_f paf,
629: hr_soft_coding_keyflex hsk
630: where paf.assignment_id = p_assignment_id
631: and paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
632: and p_session_date between paf.effective_start_date
633: and paf.effective_end_date

Line 652: hr_soft_coding_keyflex hsk

648: select paf2.assignment_id
649: into l_temp_assignment_id
650: from per_assignments_f paf1,
651: per_assignments_f paf2,
652: hr_soft_coding_keyflex hsk
653: where paf1.assignment_id = p_assignment_id
654: and paf2.person_id = paf1.person_id
655: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
656: and p_session_date between paf2.effective_start_date

Line 676: hr_soft_coding_keyflex hsk

672: select paf2.assignment_id
673: into l_temp_assignment_id
674: from per_all_assignments_f paf1,
675: per_all_assignments_f paf2,
676: hr_soft_coding_keyflex hsk
677: where paf1.assignment_id = p_assignment_id
678: and paf2.person_id = paf1.person_id
679: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
680: and hsk.segment1 = to_char(p_tax_unit_id)

Line 695: hr_soft_coding_keyflex hsk

691: /* select paf2.assignment_id
692: into l_temp_assignment_id
693: from per_assignments_f paf1,
694: per_assignments_f paf2,
695: hr_soft_coding_keyflex hsk
696: where paf1.assignment_id = p_assignment_id
697: and paf2.person_id = paf1.person_id
698: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
699: and hsk.segment1 = to_char(p_tax_unit_id)

Line 882: hr_soft_coding_keyflex hsk

878: -- check to see if p_assignment_id exist as of l_date
879: select paf.assignment_id
880: into l_temp_assignment_id
881: from per_assignments_f paf,
882: hr_soft_coding_keyflex hsk
883: where paf.assignment_id = p_assignment_id
884: and paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
885: and p_session_date between paf.effective_start_date
886: and paf.effective_end_date

Line 904: hr_soft_coding_keyflex hsk

900: select paf2.assignment_id
901: into l_temp_assignment_id
902: from per_assignments_f paf1,
903: per_assignments_f paf2,
904: hr_soft_coding_keyflex hsk
905: where paf1.assignment_id = p_assignment_id
906: and paf2.person_id = paf1.person_id
907: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
908: and p_session_date between paf2.effective_start_date

Line 927: hr_soft_coding_keyflex hsk

923: select paf2.assignment_id
924: into l_temp_assignment_id
925: from per_all_assignments_f paf1,
926: per_all_assignments_f paf2,
927: hr_soft_coding_keyflex hsk
928: where paf1.assignment_id = p_assignment_id
929: and paf2.person_id = paf1.person_id
930: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
931: and hsk.segment1 = to_char(p_tax_unit_id)

Line 946: hr_soft_coding_keyflex hsk

942: /* select paf2.assignment_id
943: into l_temp_assignment_id
944: from per_assignments_f paf1,
945: per_assignments_f paf2,
946: hr_soft_coding_keyflex hsk
947: where paf1.assignment_id = p_assignment_id
948: and paf2.person_id = paf1.person_id
949: and paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
950: and hsk.segment1 = to_char(p_tax_unit_id)