DBA Data[Home] [Help]

APPS.PAY_IP_EMPLOYEE_BALANCES dependencies on HR_SOFT_CODING_KEYFLEX

Line 822: hr_soft_coding_keyflex hsk

818: */
819: SELECT paf.assignment_id
820: INTO l_temp_assignment_id
821: FROM per_assignments_f paf,
822: hr_soft_coding_keyflex hsk
823: WHERE paf.assignment_id = p_assignment_id
824: AND paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
825: AND p_session_date BETWEEN paf.effective_start_date
826: AND paf.effective_end_date

Line 858: hr_soft_coding_keyflex hsk

854: SELECT paf2.assignment_id
855: INTO l_temp_assignment_id
856: FROM per_assignments_f paf1,
857: per_assignments_f paf2,
858: hr_soft_coding_keyflex hsk
859: WHERE paf1.assignment_id = p_assignment_id
860: AND paf2.person_id = paf1.person_id
861: AND paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
862: AND p_session_date BETWEEN paf2.effective_start_date

Line 895: hr_soft_coding_keyflex hsk

891: SELECT paf2.assignment_id
892: INTO l_temp_assignment_id
893: FROM per_assignments_f paf1,
894: per_assignments_f paf2,
895: hr_soft_coding_keyflex hsk
896: WHERE paf1.assignment_id = p_assignment_id
897: AND paf2.person_id = paf1.person_id
898: AND paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
899: AND hsk.segment1 = to_char(p_tax_unit_id)