[Home] [Help]
2256: VF_Month_Fee_Bal := 0;
2257: END IF;
2258:
2259: /*Algorithm:
2260: 1. Check individual support and total support deduction amounts against
2261: legislative limits. Also perform negative net checks.
2262: 2. If necessary, check proration rule to recalculate child support
2263: deductions to either proportionally or equally share available
2264: disposable income.
2360: total_fees_run := total_fees_run - VF_FEE_AMT + wh_fee_amt;
2361: END IF;
2362: END IF;
2363: GLB_TOTAL_WHLD_SUPPP_FEE_MNTH := GLB_TOTAL_WHLD_SUPPP_FEE_MNTH + VF_MONTH_FEE_BAL;
2364: /* Variable GLB_TOTAL_WHLD_SUPPP_FEE_MNTH captures the individual monthly balance for each
2365: garnishment fetched from the VF_MONTH_FEE_BAL parameter. This is to fix multiple garnishments
2366: and fee rule is per month.*/
2367: ELSIF GARN_FEE_FEE_RULE = 'AMT_PER_RUN' OR
2368: GARN_FEE_FEE_RULE = 'AMT_PER_RUN_ADDL' OR
6254: lv_temp_Filing_Status := 'Single 02' ;
6255:
6256: select decode(GLB_FIL_STAT(P_CTX_ORIGINAL_ENTRY_ID),'01','Single','03','Head Of HouseHold')
6257: into lv_Filing_Status_name
6258: from dual ;
6259: mesg := 'The value '|| to_char(lv_65_blind) ||' for EE or Spouse Blind / Age >= 65 is invalid '||
6260: 'for the Filing Status '|| lv_Filing_Status_name || ' and has been overridden to 2. ' ||
6261: 'Please correct the same before the next run.' ;
6262: ELSE