DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on DUAL

Line 2130: 1. Check individual support and total support deduction amounts against

2126: VF_Month_Fee_Bal := 0;
2127: END IF;
2128:
2129: /*Algorithm:
2130: 1. Check individual support and total support deduction amounts against
2131: legislative limits. Also perform negative net checks.
2132: 2. If necessary, check proration rule to recalculate child support
2133: deductions to either proportionally or equally share available
2134: disposable income.

Line 5392: from dual ;

5388: lv_temp_Filing_Status := 'Single 02' ;
5389:
5390: select decode(GLB_FIL_STAT(P_CTX_ORIGINAL_ENTRY_ID),'01','Single','03','Head Of HouseHold')
5391: into lv_Filing_Status_name
5392: from dual ;
5393: mesg := 'The value '|| to_char(lv_65_blind) ||' for EE or Spouse Blind / Age >= 65 is invalid '||
5394: 'for the Filing Status '|| lv_Filing_Status_name || ' and has been overridden to 2. ' ||
5395: 'Please correct the same before the next run.' ;
5396: ELSE