APPS.ZX_PRD_OPTIONS_MIGRATE_PKG dependencies on FND_PRODUCT_GROUPS

Line 14: L_MULTI_ORG_FLAG FND_PRODUCT_GROUPS.MULTI_ORG_FLAG%TYPE;

10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(250):= 'ZX.PLSQL.ZX_PRD_OPTIONS_MIGRATE_PKG.';
13:
14: L_MULTI_ORG_FLAG FND_PRODUCT_GROUPS.MULTI_ORG_FLAG%TYPE;
15: L_ORG_ID NUMBER(15);
16:
17: TYPE NUMBER_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
18: TYPE DATE_tbl_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 1309: FROM FND_PRODUCT_GROUPS;

1305: BEGIN
1306:
1307: SELECT NVL(MULTI_ORG_FLAG,'N')
1308: INTO L_MULTI_ORG_FLAG
1309: FROM FND_PRODUCT_GROUPS;
1310:
1311: IF L_MULTI_ORG_FLAG = 'N' THEN
1312: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
1313: IF L_ORG_ID IS NULL THEN