DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on OE_SALES_CREDIT_TYPES

Line 2605: FROM OE_SALES_CREDIT_TYPES

2601: errLogged BOOLEAN;
2602: BEGIN
2603: SELECT COUNT(QUOTA_FLAG)
2604: INTO qcnt
2605: FROM OE_SALES_CREDIT_TYPES
2606: WHERE QUOTA_FLAG = 'Y';
2607: SELECT COUNT(QUOTA_FLAG)
2608: INTO nqcnt
2609: FROM OE_SALES_CREDIT_TYPES

Line 2609: FROM OE_SALES_CREDIT_TYPES

2605: FROM OE_SALES_CREDIT_TYPES
2606: WHERE QUOTA_FLAG = 'Y';
2607: SELECT COUNT(QUOTA_FLAG)
2608: INTO nqcnt
2609: FROM OE_SALES_CREDIT_TYPES
2610: WHERE QUOTA_FLAG IS NULL
2611: OR QUOTA_FLAG = 'N';
2612: IF qcnt=0 AND nqcnt=0 THEN
2613: qtype := 'BOTH';