asdad

WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER037, 0) <> 0 -- If :p_badge is null (All selected), the first condition is true and returns all. -- If specific values are selected, the IN (:p_badge) handles the list. AND (:p_badge IS NULL OR zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge)) AND (:P_INC_TYPE IS NULL OR zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE)) AND (:P_PAY_PERIOD IS NULL OR zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD)) AND (:P_MPA_STAT IS NULL OR zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT)) AND (:P_PAYBATCH IS NULL OR zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH))

Comments

Popular posts from this blog

dev7 from eror

EPA

Unified Currency Report- Krithika