APPS.OM_SETUP_VALID_PKG dependencies on OE_CREDIT_CHECK_RULES

Line 2376: FROM OE_CREDIT_CHECK_RULES;

2372: errLogged BOOLEAN;
2373: BEGIN
2374: SELECT COUNT(CREDIT_CHECK_RULE_ID)
2375: INTO ccrcnt
2376: FROM OE_CREDIT_CHECK_RULES;
2377: IF ( ccrcnt = 0 ) THEN
2378: error_type := 'WARNING';
2379: mesg_name := 'ONT_SETVAL_CC_NOTFOUND';
2380: errLogged := writeError( entity, p_level, p_value, error_type, mesg_name,

Line 2446: FROM OE_CREDIT_CHECK_RULES

2442: error_type := 'WARNING';
2443: mesg_name := 'ONT_SETVAL_CC_PRE_CALC_EXPO';
2444: SELECT COUNT(CREDIT_CHECK_RULE_ID)
2445: INTO ccexcnt
2446: FROM OE_CREDIT_CHECK_RULES
2447: WHERE QUICK_CR_CHECK_FLAG = 'Y';
2448: SELECT COUNT(fcr.REQUEST_ID)
2449: INTO creqcnt
2450: FROM FND_CONCURRENT_REQUESTS fcr, FND_CONCURRENT_PROGRAMS_TL fcp