APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on FND_PRODUCT_GROUPS

Line 41: SELECT NVL(multi_org_flag, 'N') INTO l_multi_org_flag FROM FND_PRODUCT_GROUPS;

37: 'ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ar(+)');
38: END IF;
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: SELECT NVL(multi_org_flag, 'N') INTO l_multi_org_flag FROM FND_PRODUCT_GROUPS;
42: -- for single org environment, get value of org_id from profile
43: IF l_multi_org_flag = 'N' THEN
44: FND_PROFILE.GET('ORG_ID',l_org_id);
45: IF l_org_id is NULL THEN

Line 1905: SELECT NVL(multi_org_flag, 'N') INTO l_multi_org_flag FROM FND_PRODUCT_GROUPS;

1901: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(+)');
1902: END IF;
1903:
1904: x_return_status := FND_API.G_RET_STS_SUCCESS;
1905: SELECT NVL(multi_org_flag, 'N') INTO l_multi_org_flag FROM FND_PRODUCT_GROUPS;
1906: -- for single org environment, get value of org_id from profile
1907: IF l_multi_org_flag = 'N' THEN
1908: FND_PROFILE.GET('ORG_ID',l_org_id);
1909: IF l_org_id is NULL THEN