APPS.OM_SETUP_VALID_PKG dependencies on FND_DOC_SEQUENCE_ASSIGNMENTS

Line 2295: FROM FND_DOC_SEQUENCE_ASSIGNMENTS

2291: END;
2292: IF ( sobhr <> -1 ) THEN
2293: SELECT COUNT(DOC_SEQUENCE_ASSIGNMENT_ID)
2294: INTO actcount
2295: FROM FND_DOC_SEQUENCE_ASSIGNMENTS
2296: WHERE CATEGORY_CODE = doccat.CODE
2297: AND START_DATE <= SYSDATE
2298: AND SYSDATE <= NVL ( END_DATE, SYSDATE)
2299: AND SET_OF_BOOKS_ID = sobhr;

Line 2328: FROM FND_DOC_SEQUENCE_ASSIGNMENTS

2324: END;
2325: IF ( sobhr <> -1 ) THEN
2326: SELECT COUNT(SET_OF_BOOKS_ID)
2327: into sobcount
2328: FROM FND_DOC_SEQUENCE_ASSIGNMENTS
2329: WHERE SET_OF_BOOKS_ID = sobhr;
2330: END IF;
2331: IF ( sobcount = 0 ) THEN
2332: error_type := 'ERROR';

Line 3023: FROM FND_DOC_SEQUENCE_ASSIGNMENTS fdsa

3019: sob := -1;
3020: END;
3021: SELECT COUNT(fdsa.DOC_SEQUENCE_ASSIGNMENT_ID)
3022: INTO bolacnt
3023: FROM FND_DOC_SEQUENCE_ASSIGNMENTS fdsa
3024: ,FND_DOC_SEQUENCE_CATEGORIES fdsc
3025: WHERE SET_OF_BOOKS_ID = sob
3026: AND CATEGORY_CODE = fdsc.CODE
3027: AND fdsc.NAME = 'BOL';

Line 3030: FROM FND_DOC_SEQUENCE_ASSIGNMENTS fdsa

3026: AND CATEGORY_CODE = fdsc.CODE
3027: AND fdsc.NAME = 'BOL';
3028: SELECT COUNT(fdsa.DOC_SEQUENCE_ASSIGNMENT_ID)
3029: INTO pkslpacnt
3030: FROM FND_DOC_SEQUENCE_ASSIGNMENTS fdsa
3031: ,FND_DOC_SEQUENCE_CATEGORIES fdsc
3032: WHERE SET_OF_BOOKS_ID = sob
3033: AND CATEGORY_CODE = fdsc.CODE
3034: AND fdsc.NAME = 'PKSLP';