APPS.PAY_IN_TERMINATION_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 1483: ,hr_soft_coding_keyflex scl

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

Line 1493: l_coverage_flag hr_soft_coding_keyflex.segment8%TYPE;

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' ;

Line 3553: ,hr_soft_coding_keyflex scl

3549: ,pos.pds_information2
3550: FROM per_periods_of_service pos
3551: ,per_assignments_f paf
3552: ,per_people_f ppf
3553: ,hr_soft_coding_keyflex scl
3554: WHERE pos.period_of_service_id = p_period_of_service_id
3555: AND pos.business_group_id = p_business_group_id
3556: AND paf.assignment_id = p_assignment_id
3557: AND pos.period_of_service_id = paf.period_of_service_id