APPS.WSH_FLEX_PKG_COGS dependencies on SO_LINE_SALES_CREDITS

Line 751: FROM SO_LINE_SALES_CREDITS

747: END IF;
748: BEGIN
749: SELECT SALESREP_ID
750: INTO L_SALESREP_ID
751: FROM SO_LINE_SALES_CREDITS
752: WHERE LINE_ID = L_ORDER_LINE_ID
753: AND QUOTA_FLAG = 'Y'
754: AND SALESREP_ID = (
755: SELECT MIN(SALESREP_ID)

Line 756: FROM SO_LINE_SALES_CREDITS C1

752: WHERE LINE_ID = L_ORDER_LINE_ID
753: AND QUOTA_FLAG = 'Y'
754: AND SALESREP_ID = (
755: SELECT MIN(SALESREP_ID)
756: FROM SO_LINE_SALES_CREDITS C1
757: WHERE C1.LINE_ID = L_ORDER_LINE_ID
758: AND C1.QUOTA_FLAG = 'Y'
759: AND C1.PERCENT = (
760: SELECT MAX(PERCENT)

Line 761: FROM SO_LINE_SALES_CREDITS C2

757: WHERE C1.LINE_ID = L_ORDER_LINE_ID
758: AND C1.QUOTA_FLAG = 'Y'
759: AND C1.PERCENT = (
760: SELECT MAX(PERCENT)
761: FROM SO_LINE_SALES_CREDITS C2
762: WHERE C2.LINE_ID = L_ORDER_LINE_ID
763: AND C2.QUOTA_FLAG = 'Y'
764: AND C2.LEVEL_ID = (
765: SELECT MAX(LEVEL_ID)

Line 766: FROM SO_LINE_SALES_CREDITS C3

762: WHERE C2.LINE_ID = L_ORDER_LINE_ID
763: AND C2.QUOTA_FLAG = 'Y'
764: AND C2.LEVEL_ID = (
765: SELECT MAX(LEVEL_ID)
766: FROM SO_LINE_SALES_CREDITS C3
767: WHERE C3.LINE_ID = L_ORDER_LINE_ID
768: AND C3.QUOTA_FLAG = 'Y'
769: )
770: )