880: ,hsc.segment10
881: ,hsc.segment11
882: ,hsc.segment12
883: FROM per_assignments_f paf
884: ,hr_soft_coding_keyflex hsc
885: WHERE paf.assignment_id = p_assignment_id
886: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
887: AND paf.business_group_id = p_business_group_id
888: AND p_date BETWEEN paf.effective_start_date
887: AND paf.business_group_id = p_business_group_id
888: AND p_date BETWEEN paf.effective_start_date
889: AND paf.effective_end_date;
890:
891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
888: AND p_date BETWEEN paf.effective_start_date
889: AND paf.effective_end_date;
890:
891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
889: AND paf.effective_end_date;
890:
891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
890:
891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;
903: l_message VARCHAR2(255);
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;
903: l_message VARCHAR2(255);
904: l_procedure VARCHAR2(100);
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;
903: l_message VARCHAR2(255);
904: l_procedure VARCHAR2(100);
905:
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;
903: l_message VARCHAR2(255);
904: l_procedure VARCHAR2(100);
905:
906: BEGIN
1383: CURSOR c_gre_id
1384: IS
1385: SELECT scl.segment1
1386: FROM per_assignments_f asg,
1387: hr_soft_coding_keyflex scl
1388: WHERE asg.assignment_id = p_assignment_id
1389: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1390: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
1391:
1388: WHERE asg.assignment_id = p_assignment_id
1389: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1390: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
1391:
1392: l_tax_unit_id hr_soft_coding_keyflex.segment1%TYPE;
1393: BEGIN
1394: OPEN c_gre_id;
1395: FETCH c_gre_id INTO l_tax_unit_id;
1396: CLOSE c_gre_id;