527: )
528: AND creator_type = 'B';
529:
530: BEGIN
531: hr_utility.trace ('Entering into the function PAY_NO_HOLIDAY_PAY.GET_HOLIDAY_PAY_BASE_ASG_RUN');
532:
533: OPEN c_get_def_bal_id;
534:
535: FETCH c_get_def_bal_id
535: FETCH c_get_def_bal_id
536: INTO ln_def_bal_id;
537:
538: IF c_get_def_bal_id%FOUND THEN
539: hr_utility.trace ('def bal id for ' || p_entity_name || 'is ' || ln_def_bal_id);
540:
541: ln_balance_value := pay_balance_pkg.get_value (ln_def_bal_id, p_assignment_action_id
542: , NULL, NULL
543: , NULL, NULL
543: , NULL, NULL
544: , NULL, NULL
545: , NULL, 'TRUE');
546: ELSE
547: hr_utility.trace ('def bal id NOT FOUND for ' || p_entity_name || 'is ' || ln_def_bal_id);
548: hr_utility.raise_error;
549: END IF;
550:
551: CLOSE c_get_def_bal_id;
544: , NULL, NULL
545: , NULL, 'TRUE');
546: ELSE
547: hr_utility.trace ('def bal id NOT FOUND for ' || p_entity_name || 'is ' || ln_def_bal_id);
548: hr_utility.raise_error;
549: END IF;
550:
551: CLOSE c_get_def_bal_id;
552:
549: END IF;
550:
551: CLOSE c_get_def_bal_id;
552:
553: hr_utility.trace ('ln_balance_value '|| ln_balance_value);
554:
555: hr_utility.trace ('Leaving the function PAY_NO_HOLIDAY_PAY.GET_HOLIDAY_PAY_BASE_ASG_RUN');
556:
557: RETURN ln_balance_value;
551: CLOSE c_get_def_bal_id;
552:
553: hr_utility.trace ('ln_balance_value '|| ln_balance_value);
554:
555: hr_utility.trace ('Leaving the function PAY_NO_HOLIDAY_PAY.GET_HOLIDAY_PAY_BASE_ASG_RUN');
556:
557: RETURN ln_balance_value;
558:
559: END get_holiday_pay_base_asg_run;