DECODE("PS_DEPENDENT_BENEF"."DEPENDENT_BENEF",'02',( DECODE((MAX(DECODE("PS_HEALTH_BENEFIT"."PLAN_TYPE",'10' ,"PS_HEALTH_BENEFIT"."COVRG_CD" ) )),'4', (MAX( DECODE("PS_HEALTH_BENEFIT"."PLAN_TYPE",'10' , "PS_HEALTH_BENEFIT"."BENEFIT_PLAN") )) ,'5', (MAX( DECODE("PS_HEALTH_BENEFIT"."PLAN_TYPE",'10' , "PS_HEALTH_BENEFIT"."BENEFIT_PLAN") ) ) ) ) )
I want the benefit plan to carry over if there is a second dependent listed. Is this possible? If I add 'MAX' at the beginning then I get a ORA-00978: nested group function without GROUP BY error
I want the benefit plan to carry over if there is a second dependent listed. Is this possible? If I add 'MAX' at the beginning then I get a ORA-00978: nested group function without GROUP BY error