525: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ASG_LE_ABS_CAT_HY_YEAR');
526: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
527: CLOSE csr_Get_Defined_Balance_Id;
528:
529: pay_balance_pkg.set_context('SOURCE_TEXT',p_category_code);
530: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
531: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
532:
533: l_DAYS_IN_BALANCE := pay_balance_pkg.get_value(
526: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
527: CLOSE csr_Get_Defined_Balance_Id;
528:
529: pay_balance_pkg.set_context('SOURCE_TEXT',p_category_code);
530: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
531: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
532:
533: l_DAYS_IN_BALANCE := pay_balance_pkg.get_value(
534: P_DEFINED_BALANCE_ID => lr_Get_Defined_Balance_Id,
527: CLOSE csr_Get_Defined_Balance_Id;
528:
529: pay_balance_pkg.set_context('SOURCE_TEXT',p_category_code);
530: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
531: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
532:
533: l_DAYS_IN_BALANCE := pay_balance_pkg.get_value(
534: P_DEFINED_BALANCE_ID => lr_Get_Defined_Balance_Id,
535: P_ASSIGNMENT_ACTION_ID => p_assignment_action_id,
529: pay_balance_pkg.set_context('SOURCE_TEXT',p_category_code);
530: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
531: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
532:
533: l_DAYS_IN_BALANCE := pay_balance_pkg.get_value(
534: P_DEFINED_BALANCE_ID => lr_Get_Defined_Balance_Id,
535: P_ASSIGNMENT_ACTION_ID => p_assignment_action_id,
536: P_TAX_UNIT_ID => p_tax_unit_id,
537: P_JURISDICTION_CODE => null,