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
Post a Comment