1479: CURSOR csr_asg_details
1480: IS
1481: SELECT scl.segment8
1482: FROM per_assignments_f asg
1483: ,hr_soft_coding_keyflex scl
1484: WHERE asg.assignment_id = g_assignment_id
1485: AND asg.primary_flag = 'Y'
1486: AND p_actual_termination_date
1487: BETWEEN asg.effective_start_date
1489: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1490: AND scl.enabled_flag = 'Y' ;
1491:
1492: l_e_date CONSTANT DATE := to_date('01-04-2004','DD-MM-YYYY');
1493: l_coverage_flag hr_soft_coding_keyflex.segment8%TYPE;
1494:
1495: BEGIN
1496: g_debug := hr_utility.debug_enabled ;
1497: l_procedure := g_package ||'get_gratuity_ivs' ;
3546: ,pos.pds_information2
3547: FROM per_periods_of_service pos
3548: ,per_assignments_f paf
3549: ,per_people_f ppf
3550: ,hr_soft_coding_keyflex scl
3551: WHERE pos.period_of_service_id = p_period_of_service_id
3552: AND pos.business_group_id = p_business_group_id
3553: AND paf.assignment_id = p_assignment_id
3554: AND pos.period_of_service_id = paf.period_of_service_id